agent using mysql-connector-java-5.0.7

From: rogster <eric.d.eborn(at)lmco.com>
Date: Mon Aug 20 2007 - 12:20:17 EDT

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
--

View this message in context: http://www.nabble.com/agent-using-mysql-connector-java-5.0.7-tf4299941.html#a12239073 Sent from the MySQL - Java mailing list archive at Nabble.com.

--

MySQL Java Mailing List
For list archives: http://lists.mysql.com/java To unsubscribe: http://lists.mysql.com/java?unsub=lists@pantek.com Received on Mon Aug 20 12:20:26 2007