"Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer

[joelruisi]

Hello,

I've set up JBOSS AS 7.1 and Teiid 8.2 on WIndows. I've installed Teiid Designer 8.0 in Eclipse Juno sr1.  All I'm trying to do is "Test JDBC Connection" and it gives me the message: unable to establish connection to the jdbc server. "jdbc:teiid:ping@mm//localhost:31000". There are no errors in the log that I can see, and testing the administration connection comes back ok.  What could be causing this to happen?

Thanks in advance for any help!

Joel

[mdrillin]

Hi Joel,

What credentials are you using for the JDBC connection?  The default is user/user - this is controlled by the teiid-security-users.properties file, located in /standalone/configuration directory of your server installation.

Mark

[rareddy]

Did you start the JBoss AS 7.1 with following command

run.bat -c standalone-teiid.xml

[joelruisi]

Hi Mark,

I am using user/user, and I checked in the .properties file and that is what it's set to.

Thanks,

Joel

[mdrillin]

As Ramesh pointed out, you'll need to start JBoss with the standalone-teiid.xml configuration.  Are you starting the server from within Designer?  If so, you can point it to the standalone-teiid.xml in that setup.  Otherwise if starting JBoss from command line you'll need to specify it there.

Mark

[joelruisi]

you guys rock!!!

[biaobiaoqi]

Thanks all!

I've met with this problem too.

The default one in Designer make the lauching patameters 'standalone.xml' instead of 'standalone-teiid.xml'.

[rareddy]

Yapeng,

The reason for that is, the default is stand-alone profile in JBoss AS/EAP, thus when you install JBDS (JBoss developer tools) it defaults to that profile. Teiid is installed on top of JBoss AS/EAP in a separate profile that is only defined in a separate configuration file "standalone-teiid.xml" by default. Thus you need to start using the above commands to start Teiid specific components.

If you want in the "<jboss-eap>/bin/scripts" directory there is a script called "teiid-standalone-mode-install.cli" that will install Teiid in any profile. So, for that to work start the JBoss AS/EAP just as

standalone.sh

then in a separate console window execute

jboss-cli.sh --file=scripts/teiid-standalone-mode-install.cli

Then from now on you can just start the default JBoss AS/EAP using "standalone.xml" in designer or any other places.

HTH

Ramesh..

[biaobiaoqi]

Thx, I'll try it later.

[ranajitjana]

I am using EAP 6.3 with teiid-8.9.1-jboss-dist and found that the the property file application-users.properties was empty.

So i created users with jboss-eap-6.3\bin\add-user.bat which will write the users to the above file.

This will resolve this issue.

[biaobiaoqi]

Thanks very much!