When working with JDBC we create DSN in windows but when uploading the webapp then how shall the server know about my database and how the servlets know that where the database is present since we point to database through the DSN shall we create DSN there too or there is some other way out.
Regards<br />Syed Kamran Ali
Blake Minghelli
Ranch Hand
Joined: Sep 13, 2002
Posts: 331
posted
0
So you are currently using the jdbc-odbc bridge right? You will have better performance if you use a driver that is specific for your db. Then you don't have to worry about creating DSNs (ODBC data sources) on the client/server. Once you have your driver, you have to register it just like you do with the jdbc-odbc bridge driver. For more info on registering the driver you should be able to search this forum. Also, for a basic tutorial on JDBC, check out this Hope that helps
Blake Minghelli<br />SCWCD<br /> <br />"I'd put a quote here but I'm a non-conformist"
Sean MacLean
author
Ranch Hand
Joined: Nov 07, 2000
Posts: 621
posted
0
"kamran", Thanks for participating here at the Ranch. However, the name you are using does not comply with our naming convention described at http://www.javaranch.com/name.jsp . Please log in with a new name, which meets these requirements. You can change your name here. Thanks. Sean
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
subject: jsp hosting with database problem please help