aspose file tools*
The moose likes JDBC and the fly likes Creating table JDBC-MS-ACCESS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Creating table JDBC-MS-ACCESS" Watch "Creating table JDBC-MS-ACCESS" New topic
Author

Creating table JDBC-MS-ACCESS

Saumyaraj Zala
Ranch Hand

Joined: Aug 06, 2012
Posts: 56

After inserting the values table branch i want to create a new table.
The values come from a jsp page.
The values are getting inserted successfully but the table is not being created and it does not check the if statement i just have a blank page.
Thankyou.
Here is my code:-



Why do we fall? So that we can learn to pick ourselves up.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30324
    
150

That means an Exception is being thrown. Which you catch and log. What do the logs say?

Since the catch doesn't do anything else, that's why you aren't being redirected anywhere.


[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
Saumyaraj Zala
Ranch Hand

Joined: Aug 06, 2012
Posts: 56

Jeanne Boyarsky wrote:That means an Exception is being thrown. Which you catch and log. What do the logs say?

Since the catch doesn't do anything else, that's why you aren't being redirected anywhere.


Ya, Null Pointer Exception.
Saumyaraj Zala
Ranch Hand

Joined: Aug 06, 2012
Posts: 56

Ok I got it. I was Closing two ")" after option1..
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

I suggest you use a PreparedStatement when you have data you want to put into your SQL like that. If you do that you won't have a maze of confusing quotes to throw you off the track.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Creating table JDBC-MS-ACCESS