This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Soft Skills and have John Sonmez on-line!
See this thread for details.
The moose likes JDBC and the fly likes Need help - MySQL + Solaris Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Need help - MySQL + Solaris" Watch "Need help - MySQL + Solaris" New topic
Author

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.
Jamie
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
Greenhorn

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: www.jetools.com 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: http://aspose.com/file-tools
 
subject: Need help - MySQL + Solaris