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

Thread Solved

Join Date: Apr 2008
Posts: 29
Reputation: Visualogic is an unknown quantity at this point 
Solved Threads: 0
Visualogic Visualogic is offline Offline
Light Poster

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

 
0
  #1
Apr 23rd, 2008
do i need a connector???
Reply With Quote Quick reply to this message  
Join Date: Dec 2004
Posts: 4,190
Reputation: peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of 
Solved Threads: 483
Moderator
Featured Poster
peter_budo's Avatar
peter_budo peter_budo is offline Offline
Code tags enforcer

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

 
0
  #2
Apr 24th, 2008
No if you can create one for your self, but I would not recommend that. Better to stick with connectors....
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)

LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Reply With Quote Quick reply to this message  
Join Date: Apr 2008
Posts: 29
Reputation: Visualogic is an unknown quantity at this point 
Solved Threads: 0
Visualogic Visualogic is offline Offline
Light Poster

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

 
0
  #3
Apr 24th, 2008
which connector do u prefer???
Reply With Quote Quick reply to this message  
Join Date: Dec 2004
Posts: 4,190
Reputation: peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of 
Solved Threads: 483
Moderator
Featured Poster
peter_budo's Avatar
peter_budo peter_budo is offline Offline
Code tags enforcer

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

 
0
  #4
Apr 24th, 2008
It is more of question what database you using MySQL/MsSQL/Oracle
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)

LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Reply With Quote Quick reply to this message  
Join Date: Nov 2004
Posts: 6,143
Reputation: jwenting is just really nice jwenting is just really nice jwenting is just really nice jwenting is just really nice 
Solved Threads: 213
Team Colleague
jwenting's Avatar
jwenting jwenting is offline Offline
duckman

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

 
0
  #5
Apr 24th, 2008
and that's after you stop trying to place business logic in JSPs.
As people are clearly allowed to attack me but I'm not allowed to defend myself, I no longer post to this site.
Reply With Quote Quick reply to this message  
Join Date: Apr 2008
Posts: 29
Reputation: Visualogic is an unknown quantity at this point 
Solved Threads: 0
Visualogic Visualogic is offline Offline
Light Poster

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

 
0
  #6
Apr 24th, 2008
i am using Microsoft SQL server 2005.
Reply With Quote Quick reply to this message  
Join Date: Dec 2004
Posts: 4,190
Reputation: peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of 
Solved Threads: 483
Moderator
Featured Poster
peter_budo's Avatar
peter_budo peter_budo is offline Offline
Code tags enforcer

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

 
0
  #7
Apr 25th, 2008
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
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)

LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Reply With Quote Quick reply to this message  
Join Date: Mar 2008
Posts: 25
Reputation: blater is an unknown quantity at this point 
Solved Threads: 7
blater's Avatar
blater blater is offline Offline
Light Poster

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

 
0
  #8
Apr 25th, 2008
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
Last edited by blater; Apr 25th, 2008 at 10:02 am.
Reply With Quote Quick reply to this message  
Join Date: Apr 2008
Posts: 1
Reputation: manikandan.sri is an unknown quantity at this point 
Solved Threads: 1
manikandan.sri manikandan.sri is offline Offline
Newbie Poster

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

 
0
  #9
Apr 27th, 2008
Originally Posted by Visualogic View Post
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.
Reply With Quote Quick reply to this message  
Join Date: Apr 2008
Posts: 29
Reputation: Visualogic is an unknown quantity at this point 
Solved Threads: 0
Visualogic Visualogic is offline Offline
Light Poster

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

 
0
  #10
Apr 27th, 2008
ok, lets me try it. i am new to this.

need to learn more.
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the JSP Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC