agent using mysql-connector-java-5.0.7
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