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

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

    yapeng shen Newbie

      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.