How to establish JDBC connectivity in Websphere local servers properly?
I just started using IBM WebSphere Studio Application Developer 5.0.
I've set up a local server for a "test project". From that local server I can run my simple jsp OK, for example "Hello World"
(http://localhost:8080/TestProject/HelloWorld.jsp).
Now I need to test jsp that works with Sybase. Please tell me how to install jdbc driver properly. What files are needed? Which folders to install? How to do these things?
Can anyone please advisestep by step instructionS?
Thanks very much.
[533 byte] By [
Danny_55a] at [2007-10-3 5:53:33]
Why on earth are you using Sybase for a local development machine? MySQL is free, and much easier to work with. Here are your step-by-step instructions:
1) Download and install MySQL, MySQL Administrator, MySQL Connector/J
2) Use the MySQL Administrator to create a local database
3) The JDBC URL you need to use is "jdbc:mysql://localhost/MyDatabase"
If you don't understand these basic steps, then you'll need to do more research about JDBC and how it works.
Brian
Hi Danny,
You need to download a Sybase JDBC driver (I thnik jconnect workd fine with Sybase) and set the connection URL properly.
I have never work with Sybase but I found some links could be useful. I hope you find information you need there.
http://www.ewin.org/~bret/java/jdbc/drivers.html
http://developers.sun.com/product/jdbc/drivers
http://www.ewin.org/~bret/java/jdbc/sybase1.txt
http://www.ewin.org/~bret/java/jdbc/sybase3.html
Regards,
LJ
