Database Feature PostgreSQL

Post Reply
Steffenadensis
Posts: 31
Joined: Tue Jul 29, 2014 11:42 am

Database Feature PostgreSQL

Post by Steffenadensis » Mon Sep 29, 2014 3:02 pm

Hello,

when i try to connect to a postgresql DB,

Code: Select all

#PARSER CQL
#RUNQUERY

CREATE DATABASE CONNECTION con1 AS postgresql TO DataStreams AT x.x.x.x : 5432 WITH USER
X PASSWORD Y NO_LAZY_CONNECTION_CHECK
Odysseus reacts with:

## Stack Trace:
Message:
Check for database connection failed: No suitable driver found for jdbc:postgresql://10.9.3.67:5432/adensisDataStreams

at de.uniol.inf.is.odysseus.parser.cql.CQLParser.invokeDatabaseVisitor(CQLParser.java:1331)
at de.uniol.inf.is.odysseus.parser.cql.CQLParser.visit(CQLParser.java:1298)
at de.uniol.inf.is.odysseus.parser.cql.parser.ASTCreateDatabaseConnection.jjtAccept(ASTCreateDatabaseConnection.java:19)
at de.uniol.inf.is.odysseus.parser.cql.parser.SimpleNode.childrenAccept(SimpleNode.java:88)
at de.uniol.inf.is.odysseus.parser.cql.CQLParser.visit(CQLParser.java:180)
at de.uniol.inf.is.odysseus.parser.cql.CQLParser.parse(CQLParser.java:162)
at de.uniol.inf.is.odysseus.parser.cql.CQLParser.parse(CQLParser.java:143)
at de.uniol.inf.is.odysseus.planmanagement.compiler.standardcompiler.StandardCompiler.translateQuery(StandardCompiler.java:252)
at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.createQueries(StandardExecutor.java:247)
at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQuery(StandardExecutor.java:614)
at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQuery(StandardExecutor.java:607)
at de.uniol.inf.is.odysseus.core.server.planmanagement.executor.command.dd.AddQueryCommand.execute(AddQueryCommand.java:38)
at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQueries(StandardExecutor.java:413)
at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQuery(StandardExecutor.java:618)
at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQuery(StandardExecutor.java:607)
at de.uniol.inf.is.odysseus.planmanagement.executor.standardexecutor.StandardExecutor.addQuery(StandardExecutor.java:591)
at de.uniol.inf.is.odysseus.rcp.editor.text.commands.RunQueryCommand$1.run(RunQueryCommand.java:153)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Kind regards

T. Steffen

Operating system: Debian GNU/Linux 7.6 (wheezy)

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

Re: Database Feature PostgreSQL

Post by Marco Grawunder » Mon Sep 29, 2014 4:07 pm

I think I found the problem: The driver could not be found, because it was not in the classpath of the bundle. Its committed to svn (untestet, because I have no Postgres db here) and will be on the update site soon.

Steffenadensis
Posts: 31
Joined: Tue Jul 29, 2014 11:42 am

Re: Database Feature PostgreSQL

Post by Steffenadensis » Mon Sep 29, 2014 4:34 pm

o.k, thanks.
I will test it soon ;)
Kind regards

T. Steffen

Operating system: Debian GNU/Linux 7.6 (wheezy)

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest