CQL query validation error in database connection

Post Reply
kauerbach
Posts: 30
Joined: Fri Aug 22, 2014 4:52 pm

CQL query validation error in database connection

Post by kauerbach » Mon Oct 06, 2014 3:39 pm

Hello,

I'm trying to connect to a mysql database on the localhost with the query below but when I execute it I get the following validation error:

"Parsing and executing query has encountered a problem. Script execution error: Parsing Odysseus script failed: Exception in query validation Encountered empty query."

I do have the database access plugin installed.

----------
#PARSER CQL
#QUERY
#TRANSCFG Standard
CREATE DATABASE CONNECTION con1 AS mysql to ddumper AT localhost WITH USER root PASSWORD passwd
------------

Thank you.
Kind regards,
Ken Auerbach.

User avatar
Marco Grawunder
Posts: 272
Joined: Tue Jul 29, 2014 10:29 am
Location: Oldenburg, Germany
Contact:

Re: CQL query validation error in database connection

Post by Marco Grawunder » Mon Oct 06, 2014 3:57 pm

The solution for the problem is very simple:

#QUERY is a command that excepts a query in the next line. But you wrote another command (#TRANSCFG). So switching both lines should do the work.

Code: Select all

#PARSER CQL
#TRANSCFG Standard
#QUERY
CREATE DATABASE CONNECTION con1 AS mysql to ddumper AT localhost WITH USER root PASSWORD passwd
#TRANSCFG is not longer needed, so the following will do the job.

Code: Select all

#PARSER CQL
#QUERY
CREATE DATABASE CONNECTION con1 AS mysql to ddumper AT localhost WITH USER root PASSWORD passwd

kauerbach
Posts: 30
Joined: Fri Aug 22, 2014 4:52 pm

Re: CQL query validation error in database connection

Post by kauerbach » Mon Oct 06, 2014 4:20 pm

Hello,

Thank you. But now I'm getting a different error: "Could not initialize class de.uniol.inf.is.odysseus.database.connection.DatabaseConnection".

Here is my query:
-------
#PARSER CQL
#QUERY
CREATE DATABASE CONNECTION con1 AS mysql to ddumper AT localhost : 3306
---------

Thank you.
Kind regards,
Ken Auerbach.

User avatar
Marco Grawunder
Posts: 272
Joined: Tue Jul 29, 2014 10:29 am
Location: Oldenburg, Germany
Contact:

Re: CQL query validation error in database connection

Post by Marco Grawunder » Mon Oct 06, 2014 4:37 pm

Could you please send a BugReport so I can further investigate your problem?

Update: Have you tried:
... with USER <user> PASSWORD <password>

kauerbach
Posts: 30
Joined: Fri Aug 22, 2014 4:52 pm

Re: CQL query validation error in database connection

Post by kauerbach » Mon Oct 06, 2014 4:47 pm

Hello,

I just a bug report. Please let me know if you received it.

Thank you.
Kind regards,
Ken Auerbach.

kauerbach
Posts: 30
Joined: Fri Aug 22, 2014 4:52 pm

Re: CQL query validation error in database connection

Post by kauerbach » Mon Oct 06, 2014 4:50 pm

Hello,

I just tried it with "WITH USER user PASSWORD password" and got the same result.

Regards,
Ken Auerbach.

User avatar
Marco Grawunder
Posts: 272
Joined: Tue Jul 29, 2014 10:29 am
Location: Oldenburg, Germany
Contact:

Re: CQL query validation error in database connection

Post by Marco Grawunder » Mon Oct 06, 2014 5:01 pm

Bug report received. I will have a closer look

User avatar
Marco Grawunder
Posts: 272
Joined: Tue Jul 29, 2014 10:29 am
Location: Oldenburg, Germany
Contact:

Re: CQL query validation error in database connection

Post by Marco Grawunder » Mon Oct 06, 2014 5:28 pm

Ok. This is very strange. :?

We need to further investigate the problem.

Could you please make an update, run only this simple query (with username and password) again and send send the bug report? I will look at it tomorrow morning.

kauerbach
Posts: 30
Joined: Fri Aug 22, 2014 4:52 pm

Re: CQL query validation error in database connection

Post by kauerbach » Mon Oct 06, 2014 5:59 pm

Yes! That worked! Now I'm able to connect to the database and also send streaming data to a table in the database!

Thank you very much!!
Kind regards,
Ken Auerbach.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest