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!
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
Joined: Nov 01, 2000
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.
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).]