File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Cannot insert values into a table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Cannot insert values into a table" Watch "Cannot insert values into a table" New topic

Cannot insert values into a table

Vinod Awar
Ranch Hand

Joined: Nov 06, 2006
Posts: 129
Hi all,

iam trying to access postgresql database from my java program.The database is on my virtual machine.I can access dattabase but iam unable to insert values into table.I have set grant all previliges to that user.iam not getting any SQLException also. Am i missing something?pls suggest.

thanks in advance.
[ February 13, 2007: Message edited by: pramod awar ]
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Are you doing this insert in a transaction? Are you commiting the transaction?

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Muhammad Saifuddin
Ranch Hand

Joined: Dec 06, 2005
Posts: 1323

Originally posted by pramod awar:
Am i missing something?

Yeah maybe in your code... but can�t say where without it.

[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
I agree. Here's the link:
subject: Cannot insert values into a table
It's not a secret anymore!