7 Replies Latest reply on Nov 27, 2013 10:25 AM by biaobiaoqi

localhost...?

biaobiaoqi Nov 27, 2013 7:36 AM

Hello,

My environment is:

Jboss EAP 6.1 Alpha (also tried on Jboss EAP 6.1)

Teiid 8.4.0 Final

Deisgner 8.2

I followed "Model JDBC Source" section to integrate a MySQL data source. What I've done is as follows:

1).Create JDBC connection, and testing is OK.

2).Create source model for JDBC data source. I think it's OK too.

3).Create Teiid server instance. After starting the instance, I've tried the 'Test Administration Connection' and 'Test JDBC Connection', both is OK too.

4)Preview Data. I'm stuck with this step. After choose the table I created ahead, a dialog comes out:

"Error running preview. See log for more information."

And the Error log shows: "JDBC Source for Driver class com.mysql.jdbc.Driver was not found on server mm://...", details as follows:

eclipse.buildId=4.3.0.M20130911-1000
java.version=1.7.0_45
java.vendor=Oracle Corporation
BootLoader constants: OS=macosx, ARCH=x86_64, WS=cocoa, NL=zh_CN
Framework arguments:  -product org.eclipse.epp.package.standard.product -keyring /Users/biaobiaoqi/.eclipse_keyring -showlocation
Command-line arguments:  -os macosx -ws cocoa -arch x86_64 -product org.eclipse.epp.package.standard.product -keyring /Users/biaobiaoqi/.eclipse_keyring -showlocation


Error
Wed Nov 27 19:46:47 CST 2013
JDBC Source for Driver class com.mysql.jdbc.Driver was not found on server mm://localhost:9999::biaobiaoqi (JBoss EAP 6.1 Runtime Server)


java.lang.Exception: JDBC Source for Driver class com.mysql.jdbc.Driver was not found on server mm://localhost:9999::biaobiaoqi (JBoss EAP 6.1 Runtime Server)
  at org.teiid84.runtime.ExecutionAdmin.getOrCreateDataSource(ExecutionAdmin.java:318)
  at org.teiid.designer.runtime.TeiidServer.getOrCreateDataSource(TeiidServer.java:556)
  at org.teiid.designer.runtime.TeiidDataSourceFactory.createDataSource(TeiidDataSourceFactory.java:107)
  at org.teiid.designer.runtime.preview.PreviewManager.getOrCreateDataSource(PreviewManager.java:668)
  at org.teiid.designer.runtime.preview.PreviewManager.ensureConnectionInfoIsValid(PreviewManager.java:505)
  at org.teiid.designer.runtime.preview.PreviewManager.previewSetup(PreviewManager.java:1316)
  at org.teiid.designer.runtime.ui.preview.PreviewDataWorker$1.run(PreviewDataWorker.java:232)
  at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)

What's more, I've found out a lot of error in console after launching Teiid server:

20:29:51,843 INFO  [org.jboss.as] (Controller Boot Thread)  JBAS015951: 管理控制台侦听于 http://127.0.0.1:9990
20:29:51,843 INFO  [org.jboss.as] (Controller Boot Thread)  JBAS015874: JBoss EAP 6.1.0.GA (AS 7.2.0.Final-redhat-8) started in 5339ms - Started 349 of 430 services (80 services are passive or on-demand)
20:29:52,029 ERROR [org.jboss.remoting.remote.connection] (Remoting "biaobiaoqidemacbook-pro:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer
20:29:52,030 ERROR [org.jboss.remoting.remote.connection] (Remoting "biaobiaoqidemacbook-pro:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer
20:29:52,102 ERROR [org.jboss.remoting.remote.connection] (Remoting "biaobiaoqidemacbook-pro:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer
20:29:52,103 ERROR [org.jboss.remoting.remote.connection] (Remoting "biaobiaoqidemacbook-pro:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer
20:29:53,031 ERROR [org.jboss.remoting.remote.connection] (Remoting "biaobiaoqidemacbook-pro:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer
20:29:53,033 ERROR [org.jboss.remoting.remote.connection] (Remoting "biaobiaoqidemacbook-pro:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer
20:29:53,084 ERROR [org.jboss.remoting.remote.connection] (Remoting "biaobiaoqidemacbook-pro:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer
20:29:53,086 ERROR [org.jboss.remoting.remote.connection] (Remoting "biaobiaoqidemacbook-pro:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer
20:29:53,088 ERROR [org.jboss.remoting.remote.connection] (Remoting "biaobiaoqidemacbook-pro:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer
20:29:53,089 ERROR [org.jboss.remoting.remote.connection] (Remoting "biaobiaoqidemacbook-pro:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer
20:29:53,090 ERROR [org.jboss.remoting.remote.connection] (Remoting "biaobiaoqidemacbook-pro:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer
20:29:53,144 ERROR [org.jboss.remoting.remote.connection] (Remoting "biaobiaoqidemacbook-pro:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer
20:29:53,147 ERROR [org.jboss.remoting.remote.connection] (Remoting "biaobiaoqidemacbook-pro:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer
20:29:53,148 ERROR [org.jboss.remoting.remote.connection] (Remoting "biaobiaoqidemacbook-pro:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer
20:29:53,156 ERROR [org.jboss.remoting.remote.connection] (Remoting "biaobiaoqidemacbook-pro:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer
20:29:53,158 ERROR [org.jboss.remoting.remote.connection] (Remoting "biaobiaoqidemacbook-pro:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer

I've searching the Internet but haven't found any useful infomation that I can understand and apply in my case. I don't quite understand how to handle this. As connection to mysql is tested, how did this happen?

Thanks a lot in advance for any help.

1. Re: JDBC Source for Driver class com.mysql.jdbc.Driver was not found on server mm://localhost...?

rareddy Nov 27, 2013 7:35 AM (in response to biaobiaoqi)

There is an issue with the MySQL driver not being jdbc4 service compatible. Configure MySQL driver using instructions here Data Source Configuration in AS 7 then preview again. Typically Designer does deploy the JDBC driver to the server under covers, but they need to be JDBC4 Service compatible for their Driver classes.

Ramesh..
Actions
2. Re: JDBC Source for Driver class com.mysql.jdbc.Driver was not found on server mm://localhost...?

biaobiaoqi Nov 27, 2013 8:24 AM (in response to rareddy)

hi, Ramesh

Thanks very much for your help.
I've tried the first way in your link,(I use mysql-connector-java-5.1.0-bin.jar) and put the modified jar into $Jboss/standalone/deployments/. Then, I restart the server and preview again, it's still wrong with the same error infomation.

Is that not this problem? What about the error : ERROR [org.jboss.remoting.remote.connection] (Remoting "biaobiaoqidemacbook-pro:MANAGEMENT" read-1) JBREM000200: Remote connection failed: java.io.IOException: Connection reset by peer

Is there any chance that the above error make preview not good?
Actions
3. Re: JDBC Source for Driver class com.mysql.jdbc.Driver was not found on server mm://localhost...?

rareddy Nov 27, 2013 8:30 AM (in response to biaobiaoqi)

Do you see any errors on the server log? You can also try latest Teiid Designer 8.3.CR1 that is designed to work well with Teiid 8.4.
Actions
4. Re: JDBC Source for Driver class com.mysql.jdbc.Driver was not found on server mm://localhost...?

shawkins Nov 27, 2013 8:38 AM (in response to rareddy)

The server instance in Designer could be configured with an invalid management password. At least it produces the same error: [JBIDE-16133] No indication that management authentication fails - JBoss Issue Tracker

I gather though that JBREM002000 is a catch all so there could be a number of things wrong.
Actions
5. Re: JDBC Source for Driver class com.mysql.jdbc.Driver was not found on server mm://localhost...?

biaobiaoqi Nov 27, 2013 9:27 AM (in response to rareddy)

Thank you all. I've made a successful query now.
I found out that when make a RDBMS connection, I use a mysql-jdbc-5.1.0.jar without special instruments. Is that the key point?

@Steven Hawkins, I've tried the Administration Connection test, it's OK. Do you mean that?
Actions
6. Re: JDBC Source for Driver class com.mysql.jdbc.Driver was not found on server mm://localhost...?

rareddy Nov 27, 2013 9:47 AM (in response to biaobiaoqi)

What special instruments? Can you explain?
Actions
7. Re: JDBC Source for Driver class com.mysql.jdbc.Driver was not found on server mm://localhost...?

biaobiaoqi Nov 27, 2013 10:25 AM (in response to rareddy)

Sorry for an unclear description, I mean the way your link provided to make it compatible.
Actions

Go to original post