aspose file tools
The moose likes JSP and the fly likes jsp hosting with database problem please help Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Java » JSP
Reply Bookmark "jsp hosting with database problem please help" Watch "jsp hosting with database problem please help" New topic
Author

jsp hosting with database problem please help

kamran
Greenhorn

Joined: Sep 12, 2002
Posts: 8
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
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
"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
 
Similar Threads
Creating DSN
Database connection / DSN
Creating dsn files
Using File DSN
connectivity in war file