wood burning stoves 2.0*
The moose likes Java in General and the fly likes derby problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » Java in General
Bookmark "derby problem" Watch "derby problem" New topic
Author

derby problem

Suleman zia
Ranch Hand

Joined: Apr 19, 2007
Posts: 70
Hello all,
I am using JBuilder 2007. i am running the builtin derby database. i made a servlet and tried to connect it with my database but for some reason it throws an SQL exception that

Error.java.sql.SQLException: No suitable driver

here is my code.


and here is my database code


Thanks for the help


SCJP 1.5
Jesper de Jong
Java Cowboy
Saloon Keeper

Joined: Aug 16, 2005
Posts: 14193
    
  20

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

The JDBC/ODBC bridge driver is the wrong driver for Derby. Try this:

Class.forName("org.apache.derby.jdbc.EmbeddedDriver");


Java Beginners FAQ - JavaRanch SCJP FAQ - The Java Tutorial - Java SE 8 API documentation
Suleman zia
Ranch Hand

Joined: Apr 19, 2007
Posts: 70
Ok i got it.


EVerything works fine. so now when i run my servlet through tomcat5.0 and try to enter the fields firstname, lastname, username, password and click on button submit it gives me an error stating table USERS does not exist. How? Why? when i can see my table USERS in the database explorer. any ideas?
Suleman zia
Ranch Hand

Joined: Apr 19, 2007
Posts: 70
Dont ask me how but i changed my table to USERS.posts and it worked lol looks like in derby whenever you would like to create a table you need to add .posts.

Thankyou rancer always helpful :--)

Hope to bug you for my next task
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: derby problem