JSP with SQL
[246 byte] By [ema_ja] at [2007-10-2 23:47:29] 
i want to connect JSP with SQL Server but i can't install the driver for SQL. i took installation driver but i can't start the installation, it is some jar file and when i want to start install it show me error- the file path is invalid.
«« JSF : Graph : Master Detail VO: Default value is taking precedence always
»» skel file not generated in rmic compilation
»» skel file not generated in rmic compilation
To install a JDBC driver it just has to be included in the class path where the classloader can find it.
For a web application, that most easily means the WEB-INF/lib directory.
To use connection pooling provided by the container, you normally have to put it in a more general location. eg for Tomcat, you have to put it in /common/lib where it can be used by both Tomcat and your web apps.
I would suggest you read the documentation that comes with your driver. Specifically "how to install and connect" would be of use.
evnafetsa at 2007-7-14 16:32:15 >
I includede the file in Program Files\Java\jdk 1.5.0_06\lib and now I get an other message -Failed to load Main-Class manifest attribute from C:\Program Files\Java\jdk 1.5.0_06\lib\connectjdbc.jar.
Maybe I didn't include it on the right place I tryed in jre 1.5.0_06.
Idon't have any documentation for the driver only, a litle explanation that i should put it in the Program Files.
help
ema_ja at 2007-7-14 16:32:15 >
Which specific driver are you using?connectjdbc.jar.Is that the datadirect jdbc
evnafetsa at 2007-7-14 16:32:15 >
Yes it is datadirect jdbc driver but I also tryed with Microsoft SQL 2000/2005 driver. It is sqljdbc.jar file and there's the same error.
ema_ja at 2007-7-14 16:32:15 >
I finally success to install the datadirect Driver but when I write the code like Class.forName("com.ddtek.jdbc.sqlserver.SQLServerDriver") there's an exception that the compiler can't find the class or there's no comatible driver.
I'm using NetBeans IDE 5.0 Beta as Java compiler, I did the installation in Program Files/Java/jdkj 1.5.0_06, but the NetBeans IDE is other folder. Did I install the driver on the right place or I should install it somewhere in NetBeans IDE ?
ema_ja at 2007-7-14 16:32:15 >
Enterprise & Remote Computing New Topic
- JSF : Graph : Master Detail VO: Default value is taking precedence always
- IP timeout when connecting to tomcat
- how to upload and retrieve an image from
- Count the number of visitor, display on welcome page, limit only 1 for next
- Database in Servlet/JSP
- User Rights
- how to use <c:if with or(||), is possible?>
- Conveter for DataTable that has access to DataModel row variable?
Enterprise & Remote Computing Hot Topic
- why cant i connect to DB from servlet?
- Showing the contents of a mysql table...
- logic:messagesPresent not worked
- How to persist "Set<String>" with Java Persistence API ?
- JSP ODBC ERRORS :- PLEASE HELP :- UNABLE TO START THE WEB APPLICATION
- Error while sending attachments
- Displaying Bean values
- dynamically populating values in 2 dependent <select> in jsp
Enterprise & Remote Computing
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding