dcsimg
servlets with mSQL
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   srinivas_rao
Posted On:   Saturday, April 28, 2001 06:59 AM

i could't able to work with servlets using mSQL as database. Iam working with JavaWebServer, windows O.S and database is mSQL. If i written simple stand-alone application using java, i am able to connect to mSQL, the problem i am getting is only when servlets trying to connect to mSQL.

Help in this matter ASAP

Thankyou,

regards,
-srinivas

Re: servlets with mSQL

Posted By:   Michael_Wollenhaupt  
Posted On:   Saturday, April 28, 2001 11:47 AM

Yes, you could use it.
You could use a Type IV JDBC Driver from
http://mmmysql.sourceforge.net/
You have to load the driver with class.forName("org.gjt.mm.mysql.Driver").newInstance()
and then something like this:
DriverManager.setLoginTimeout(timeout);
verbindung = DriverManager.getConnection("jdbc:mysql://" + dbhost + ":" + dbport + "/"
+ dbpfad + "?user=" + dbuser + "&" + "password="
+ dbpass + "&autoReconnect=false");
See for it the manual form the mm.mysql driver .

Greetings,
Michael
wolle@dorf.rwth-aachen.de
About | Sitemap | Contact