File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Need help - MySQL + Solaris Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Need help - MySQL + Solaris" Watch "Need help - MySQL + Solaris" New topic

Need help - MySQL + Solaris

Ben Roy
Ranch Hand

Joined: Nov 01, 2000
Posts: 70
My native environment is windows (Jbuilder for development) but I'm working on a project on Solaris. What I've done before to access a MySQL database is configure an odbc source in windows, then use the jdbc dbc driver to access the data. So the db url is something like jdbc dbc:datasourcename. What I can't figure out is, now that I've moved the code to solaris, how do I create the odbc data source? Assuming I could create a datasource named the same as on my windows machine, I shouldn't need to change any of the actual code. Any help on how I do this would be great!
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

just wondering why you don't use the free Type4 driver for mySQL? You wouldn't have to worry about dsn's and odbc stuff.
Ben Roy
Ranch Hand

Joined: Nov 01, 2000
Posts: 70
Because...I don't know anything about that. ODBC is something I'm familiar with, it's the way I've worked with databases in Java in the past, it give me a consistent interface, and I *shouldn't* need to change drivers when changing databases/platforms.
zou xiao fei

Joined: Oct 26, 2001
Posts: 9
In fact,you do need type4 driver if you wanna your apps run on any platform.when using odbc,you are restricted in windows, if you insist in doing so,you need something else,just check this: and that's a type3 driver
and, I suggest you to learn more about the jdbc driver types,I 'm sure you'll choose type4 driver.
[This message has been edited by zou xiao fei (edited November 29, 2001).]
I agree. Here's the link:
subject: Need help - MySQL + Solaris
It's not a secret anymore!