aspose file tools*
The moose likes JDBC and the fly likes Unable To connect to Database !! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Unable To connect to Database !!" Watch "Unable To connect to Database !!" New topic
Author

Unable To connect to Database !!

Chetan Chauhan
Greenhorn

Joined: Oct 03, 2006
Posts: 8
Hello Everybody !!

I use NetBeansIDE4.1 for developing jsp and servlet applications.

It comes with bundled in Tomcat-5.5.7.

I wrote a simple code for database connectivity using MS-ACCESS and
system-DSN

Here is the piece of code:

Connection con;
Statement stat;
String NewLanguage=new String("SPANISH");
String sql=new String("insert into languages values (1,'" + NewLanguage.toLowerCase() + "',1,null,null)");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbcdbc:dsn_lang");
stat=con.createStatement();
stat.executeUpdate(sql);
stat.close();
con.commit();

out.println("<h1>New Language Added...</h1>");


stat.close();
con.close();
}catch(Exception e){}
}
It is working fine.

But when i try to deploy the .war file onto a separate machine with TOMCAT-5.5.9 and java libraries and MS-ACCESS database,the code doesnt work. Jsp messages and other effects are running properly but stuff from database is not coming on the page. System-DSN is also proper.

Then i installed TOMCAT 5.5.9 on my machine and called it inside NetBeansIDE4.1. Again the project run fine.

Then what happens when i run the project outside the IDE on the same or different TOMCAT server ?

Can anybody please solve my problem ?
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29287
    
140

Chetan,
the code doesnt work

Can you expand on this? What happens - error message, nothing returned, code kills JVM, ...

Since it works on one machine and not another, I would think it is a configuration problem. Check the driver is installed and the path to it is correct/in your classpath.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
George Stoianov
Ranch Hand

Joined: Jan 15, 2006
Posts: 94
Since you are using odbc make sure you have the same odbc source set up with the same name on the other machine. Otherwise it is not going to work.
George
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Unable To connect to Database !!
 
Similar Threads
visual J++ and retreiving rows from sql server
Making ResultSet unEditable
NetBeansIDE4.1 and Tomcat
Database Problem
JSP error: invalid arguments in call . PLEASE HELP