Connecting To Mysql 4.1 With Mm-classes

[terryburton]

Hi.

I'm attempting to write an application for Psion/Teklogix 7535 handhelds using the Jeode EVM (based on the Personal Java spec / Java 1.1. that needs to connect to a MySQL 4.1 database server.

I have been able to successfully write apps that connect to a MySQL 3 server using the old Connector/J classes (mm-classes) however it would appear that the binary format for the connection has changed for later MySQL versions.

The most recent version of Connector/J which supports MySQL 4 is incompatible with Java 1.1 which means that I may have to resort to writing a middle-layer transport system... not pleasant!

Has anybody has any success connecting Personal Java apps to MySQL 4?


Tez

[Omicron]

Have you thought bout determining the offedning 1.1 class and then importing the later version and using the classloader to ensure to you get (the correct class version and) the necessary compatibility.

Certainly not an easy solution, but probably easier than writing a transport.

Hope this helps.