Problem with JDBC Source postgres with Teiid 8.x

[giuseppe.lastella]

Hello guys,

i''m starting to use Teiid and i saw this Tutorial: https://babbage.inf.unibz.it/trac/obdapublic/wiki/BookFederationTutorial#no1

In the  'System Setup' i must create a Postgres Connection Profile and i must select the JDBC driver.
The system couldn't find the defualt driver JDBC .jar and i  had added an external .jar file like JDBC driver.

At the end of tutorial, i try the system for obtain a data preview but the system show me this error:

"JDBC Source for Driver class org.postgresql.Driver was not found on server BookFederationServer (mm://localhost:9999::admin)"

Someone can help me to resolve this problem??

Thanks a lot

Giuseppe

[shawkins]

It sounds like the jar was not deployed to the server.

[giuseppe.lastella]

I look at server output console and i read this:

16:58:15,648 INFO  [org.jboss.as.server] (Controller Boot Thread)  JBAS018559: Deployed "postgresql-8.1-404.jdbc2.jar"

16:58:15,648 INFO  [org.jboss.as.server] (Controller Boot Thread)  JBAS018559: Deployed "postgresql-8.1-404.jdbc3.jar"

I think that what you suppose it's wrong.

When i try to set 'Connection Profile' on my file .xmi i see these server output in console:

17:00:08,244 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-8)  JBAS015877: Stopped deployment postgresql-8.1-404.jdbc2.jar in 8ms

17:00:08,245 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-7)  JBAS015876: Starting deployment of "postgresql-8.1-404.jdbc2.jar"

17:00:08,448 INFO  [org.jboss.as.server] (management-handler-thread - 6)  JBAS018565: Replaced deployment "postgresql-8.1-404.jdbc2.jar" with deployment "postgresql-8.1-404.jdbc2.jar"

and the system generate this error:

JDBC Source for Driver class org.postgresql.Driver was not found on server BookFederationServer (mm://localhost:9999::admin)

[rareddy]

Giuseppe,

The Postgres driver is needed in two different places. One in the designer to import that metadata and also in the Teiid Server to fetch the data when you issue queries. Typically when using the Designer, if you added the jar file during the import, that JAR file is automatically deployed to server for your use. However, in your case from above log there seems to two separate postgres jar files. I am not sure where the problem is, however server is saying that the driver for Postgres is not found.

Ramesh..

[giuseppe.lastella]

Ramesh,

there are two instance of Postgres JDBC Driver deployed because in file standalone-teiid.xml has two postgres jdbc drive deploy tag.

However i dont' know how to explain me the restart of the JDBC deploy when i try to set a connection profile.

Anyway thanks a lot Ramesh.

Regards

Giuseppe

[giuseppe.lastella]

Guys,

i have found the solution about my problem on this tutorial http://kousikraj.me/2011/11/25/datasource-configuration-setup-for-jboss-as-7-with-example-of-postgresql/
Thanks a lot how replay me!!

[rareddy]

You can also look in "docs/teiid/datasources" directory for sample XML files or CLI command need to create a data source. We were trying avoid creating manually and want to create it directly from Designer. Either way, glad it is working now for you.

Ramesh..