Apps MySQL Connector/J 5.1 NOT Compatible with JDK1.7 ?!?

[ac4android]

Hi.

Strictly on a prove-of-concept basis, I want to do a remote access from A/S 1.5.1 (SDK 1.7) to a MySQL-server without using PHP or Tomcat. Just to see if I can execute simple SQL from my "preparedStatement". Word is, one can, but not recommended.

I've downloaded the community version of Connector/J 5.1.39 then unpacked and loaded the bin.jar (and just the bin.jar) to apps/libs and sync-ed the gradle.

When I tried to test the connection by running the app, I got incompatability errors and on reading even more of the documentation and release notes, I need to DOWNGRADE from SDK 1.7 to SDK 1.6 and even SDK 1.5

But all my other A/S projects run on SDK 1.7.

QUESTION:
Can I download older SDK versions and make only the TestConnection in A/S use it?


P.S. Works fine, wonderful, in Eclipse Mars.

 

[Deleted User]

Good luck!

 

[ac4android]

Good luck!

Bit more help would be nice...

How do you run in A/S with --stacktrace anyway?

 

[Deleted User]

Sorry, I was being flippant. I did some searching on this problem, and I don't think you can get the MySQL connector JDBC client library to work with Android, and establish a native connection to a remote MySQL database. The recommendation is to use a web service.

 

[ac4android]

Sorry, I was being flippant. I did some searching on this problem, and I don't think you can get the MySQL connector JDBC client library to work with Android, and establish a native connection to a remote MySQL database. The recommendation is to use a web service.

Agreed.

I got carried away after some nice experience with Java SDK1.7 and Connector/J.

For now, until I've set up a web service, I'll try PHP