-
1. Re: Problem with JDBC Source postgres with Teiid 8.x
shawkins Sep 11, 2014 9:37 AM (in response to giuseppe.lastella)It sounds like the jar was not deployed to the server.
-
2. Re: Problem with JDBC Source postgres with Teiid 8.x
giuseppe.lastella Sep 11, 2014 11:08 AM (in response to shawkins)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)
-
3. Re: Problem with JDBC Source postgres with Teiid 8.x
rareddy Sep 11, 2014 12:14 PM (in response to giuseppe.lastella)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..
-
4. Re: Problem with JDBC Source postgres with Teiid 8.x
giuseppe.lastella Sep 11, 2014 12:33 PM (in response to rareddy)1 of 1 people found this helpfulRamesh,
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
-
5. Re: Problem with JDBC Source postgres with Teiid 8.x
giuseppe.lastella Sep 12, 2014 5:10 AM (in response to 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!! -
6. Re: Problem with JDBC Source postgres with Teiid 8.x
rareddy Sep 12, 2014 7:44 AM (in response to giuseppe.lastella)1 of 1 people found this helpfulYou 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..