JDBC Connection problem.

[chyrl]

Greetings,

You may proceed to this link for the program

I am wondering to why this program connects to the MySQL of XAMPP on Netbeans 6.9.1.
But when I'm running it on Google Chrome (I don't know about the other browsers), it doesn't

What could be the cause?
Lacking of MySQL Library?

Your reply is greatly appreciated.

Thanks,
Cyril Horad

[chyrl]

What could be the cause?
I uploaded the mysql-connector-java-5.1.6 to the htdocs where the index.html is located. Yet I cannot connect?

You may download the source code of these here.

The error lies here:
Controller.java : line 30

Class.forName(driver).newInstance();

[Tolls]

What error?
It is Monday morning so I may have missed it, but I don't think you've actually told us what exception you're getting.

[chyrl]

Upon connecting. This exception appears to the Java Console

Exception in thread "AWT-EventQueue-2" java.lang.ClassFormatError: Incompatible magic value 1008813135 in class file com/mysql/jdbc/Driver
	at java.lang.ClassLoader.defineClass1(Native Method)
	at java.lang.ClassLoader.defineClassCond(Unknown Source)
	at java.lang.ClassLoader.defineClass(Unknown Source)
	at java.security.SecureClassLoader.defineClass(Unknown Source)
	at sun.plugin2.applet.Applet2ClassLoader.findClass(Unknown Source)
	at sun.plugin2.applet.Plugin2ClassLoader.loadClass0(Unknown Source)
	at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source)
	at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Unknown Source)
	at mysqlConnect.Controller.connect(Controller.java:30)
	at mysqlConnect.Controller.access$100(Controller.java:12)
	at mysqlConnect.Controller$ButtonHandler.actionPerformed(Controller.java:71)
	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)

[Tolls]

That's usually a sign that the Driver version and your JDK/JRE version are incompatrible, that is the Driver was compiled under a later version of Java. What version of Java are you running?

[chyrl]

Actually the applet runs on a web host.
When I run the applet on my computer, the program runs.
But when it runs of the link above, it doesn't.

Isn't that the JDK would run on client based protocol?
Plus, I have included the MySQL Driver on the same directory where the index file is located.

[Tolls]

Actually, looking at this again I have the wrong error in mind.
The magic number one is the check for a valid class file format (CAFEBABE?).

I wonder if the server is refusing to supply the requested jar file...or if it doesn't have it available for some reason.

[chyrl]

Ouch...
Anyways... do you know a web hosting site that could solve this thread?

[Tolls]

No idea about hosting I'm afraid.
Have you deployed the driver.jar on the server as well as your applet code?

[chyrl]

I have upload the driver in the same directory of the index.html where the applet is called.
I'm not sure that it is the proper way.

[Tolls]

Neither am I...you want to track down Norm.
He's usually in the Applets part of the forum, so stick a thread in there with a link to this thread.

[chyrl]

And what would be the subject?

[Tolls]

Applet jar file problems?
It looks to me like the attempt by the JVM to get hold of the Driver jar file is failing.
I expect if you translated that magic value it would be the start of some HTML, probably for a 404 not found.

[chyrl]

I'm not familiar with those magic values and exceptions.
To be honest, I'm knew to applets and servlets.

Maybe Norm would browse this thread without opening a new one.

[Tolls]

Your choice.