« Return to Thread: agent using mysql-connector-java-5.0.7

agent using mysql-connector-java-5.0.7

by rogster :: Rate this Message:

Reply to Author | View in Thread

Hi all.  I'm developing a simple agent that connects to mySQL and displays the table contents on the client side (this is just a baby step towards the end project).

I've installed mysql-connector-java-5.0.7 and modified the CLASSPATH variable.  And then I developed a simple class that displayed the database's contents.  It worked fine.  So I gather that the connector isnt the problem here.   However, when I developed a barebones agent that simply outputs text to the screen and then for its task implements the java-mysql-connector class, I get the following error.

Having browsed through some other posts here, I found some advice to put the connector.jar file into my agent server's lib directory.  I did this with no effect.

Any bright ideas?

jvm 1    | java.io.IOException: atp://SLCWLKR9949:4434/com/mysql/jdbc/Driver.class
jvm 1    |      at com.ibm.net.protocol.atp.URLConnectionForATP.getInputStream(URLConnectionForATP.java:135)
jvm 1    |      at com.ibm.aglets.tahiti.AgletClassLoader.loadResourceFromCodeBase(AgletClassLoader.java:556)
jvm 1    |      at com.ibm.aglets.tahiti.AgletClassLoader.access$000(AgletClassLoader.java:70)
jvm 1    |      at com.ibm.aglets.tahiti.AgletClassLoader$1.run(AgletClassLoader.java:317)
jvm 1    |      at java.security.AccessController.doPrivileged(Native Method)
jvm 1    |      at com.ibm.aglets.tahiti.AgletClassLoader.getResourceAsByteArray(AgletClassLoader.java:313)
jvm 1    |      at com.ibm.aglets.tahiti.AgletClassLoader.findByteCode(AgletClassLoader.java:185)
jvm 1    |      at com.ibm.aglets.tahiti.AgletClassLoader.loadClassFromCodeBase(AgletClassLoader.java:444)
jvm 1    |      at com.ibm.aglets.tahiti.AgletClassLoader.findClassInternal(AgletClassLoader.java:241)
jvm 1    |      at com.ibm.aglets.tahiti.AgletClassLoader.loadClass(AgletClassLoader.java:396)
jvm 1    |      at java.lang.ClassLoader.loadClass(Unknown Source)
jvm 1    |      at java.lang.ClassLoader.loadClassInternal(Unknown Source)
jvm 1    |      at java.lang.Class.forName0(Native Method)
jvm 1    |      at java.lang.Class.forName(Unknown Source)
jvm 1    |      at com.lmco.maf.agent.Jdbc_test.mysql(Jdbc_test.java:28)
jvm 1    |      at com.lmco.maf.agent.MySQL_Test.performTask(MySQL_Test.java:68)
jvm 1    |      at com.orincon.bluejai.aglets.GenericMobileAgent.sensorRun(ORINCON)
jvm 1    |      at com.orincon.bluejai.aglets.DAIWFSensorAglet.handleMessage(ORINCON)
jvm 1    |      at com.orincon.bluejai.aglets.GenericMobileAgent.handleMessage(ORINCON)
jvm 1    |      at com.ibm.aglets.MessageImpl.handle(MessageImpl.java:203)
jvm 1    |      at com.ibm.aglets.AgletThread.run(AgletThread.java:104)
jvm 1    | java.io.IOException: java.io.IOException:atp://SLCWLKR9949:4434/com/mysql/jdbc/Driver.class
jvm 1    |      at com.ibm.net.protocol.atp.URLConnectionForATP.getInputStream(URLConnectionForATP.java:139)
jvm 1    |      at com.ibm.aglets.tahiti.AgletClassLoader.loadResourceFromCodeBase(AgletClassLoader.java:556)
jvm 1    |      at com.ibm.aglets.tahiti.AgletClassLoader.access$000(AgletClassLoader.java:70)
jvm 1    |      at com.ibm.aglets.tahiti.AgletClassLoader$1.run(AgletClassLoader.java:317)
jvm 1    |      at java.security.AccessController.doPrivileged(Native Method)
jvm 1    |      at com.ibm.aglets.tahiti.AgletClassLoader.getResourceAsByteArray(AgletClassLoader.java:313)
jvm 1    |      at com.ibm.aglets.tahiti.AgletClassLoader.findByteCode(AgletClassLoader.java:185)
jvm 1    |      at com.ibm.aglets.tahiti.AgletClassLoader.loadClassFromCodeBase(AgletClassLoader.java:444)
jvm 1    |      at com.ibm.aglets.tahiti.AgletClassLoader.findClassInternal(AgletClassLoader.java:241)
jvm 1    |      at com.ibm.aglets.tahiti.AgletClassLoader.loadClass(AgletClassLoader.java:396)
jvm 1    |      at java.lang.ClassLoader.loadClass(Unknown Source)
jvm 1    |      at java.lang.ClassLoader.loadClassInternal(Unknown Source)
jvm 1    |      at java.lang.Class.forName0(Native Method)
jvm 1    |      at java.lang.Class.forName(Unknown Source)
jvm 1    |      at com.lmco.maf.agent.Jdbc_test.mysql(Jdbc_test.java:28)
jvm 1    |      at com.lmco.maf.agent.MySQL_Test.performTask(MySQL_Test.java:68)
jvm 1    |      at com.orincon.bluejai.aglets.GenericMobileAgent.sensorRun(ORINCON)
jvm 1    |      at com.orincon.bluejai.aglets.DAIWFSensorAglet.handleMessage(ORINCON)
jvm 1    |      at com.orincon.bluejai.aglets.GenericMobileAgent.handleMessage(ORINCON)
jvm 1    |      at com.ibm.aglets.MessageImpl.handle(MessageImpl.java:203)
jvm 1    |      at com.ibm.aglets.AgletThread.run(AgletThread.java:104)
jvm 1    | Exception: com.mysql.jdbc.Driver

 « Return to Thread: agent using mysql-connector-java-5.0.7