DaniWeb IT Discussion Community - can i know what software shall i use to connect jsp file to the database?

Show 40 post(s) from this thread on one page

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- JSP (http://www.daniweb.com/forums/forum24.html)

- - can i know what software shall i use to connect jsp file to the database? (http://www.daniweb.com/forums/thread120693.html)

Visualogic

Apr 23rd, 2008 10:24 pm

can i know what software shall i use to connect jsp file to the database?

do i need a connector???

peter_budo

Apr 24th, 2008 5:15 am

Re: can i know what software shall i use to connect jsp file to the database?

No if you can create one for your self, but I would not recommend that. Better to stick with connectors....

Visualogic

Apr 24th, 2008 5:30 am

Re: can i know what software shall i use to connect jsp file to the database?

which connector do u prefer???

peter_budo

Apr 24th, 2008 6:07 am

Re: can i know what software shall i use to connect jsp file to the database?

It is more of question what database you using MySQL/MsSQL/Oracle

jwenting

Apr 24th, 2008 11:34 am

Re: can i know what software shall i use to connect jsp file to the database?

and that's after you stop trying to place business logic in JSPs.

Visualogic

Apr 24th, 2008 10:24 pm

Re: can i know what software shall i use to connect jsp file to the database?

i am using Microsoft SQL server 2005.

peter_budo

Apr 25th, 2008 6:23 am

Re: can i know what software shall i use to connect jsp file to the database?

Ouch, you just hurt my feelings....
Why you not using MySQL, it is more easier to work with (in my opinion). If you wish to stay with MsSQL you need to get your self ODBC connector and learn to use it

blater

Apr 25th, 2008 9:51 am

Re: can i know what software shall i use to connect jsp file to the database?

You need to download the sql server 2005 jdbc driver (sqljdbc.jar) and make sure it is on the application server/servlet container's CLASSPATH.
An easy way of doing this is to put sqljdbc.jar in your webapps WEB-INF/lib directory.

There is plenty of documentation on MSDN on how to use it. A good basic example is here

manikandan.sri

Apr 27th, 2008 5:13 am

Re: can i know what software shall i use to connect jsp file to the database?

Quote:

Originally Posted by Visualogic (Post 591853)

do i need a connector???

HI My Friend,
Pl. avoid to connect to database from jsp file using any software. Pl. Write Separate Coding for connect Database in this coding using type 4 driver. it is very easy to connect all database without DSN name creation.

If you connect DATABASE using any database you cannot transfer context any system it is no easy.

So, Pl. Write java coding you connect database server side.

Visualogic

Apr 27th, 2008 9:49 pm

Re: can i know what software shall i use to connect jsp file to the database?

ok, lets me try it. i am new to this.

need to learn more.

All times are GMT -4. The time now is 9:02 pm.

Show 40 post(s) from this thread on one page