wood burning stoves 2.0*
The moose likes JDBC and the fly likes Regarding insertion in postgresql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Regarding insertion in postgresql" Watch "Regarding insertion in postgresql" New topic
Author

Regarding insertion in postgresql

Sreejith Padmanabhan
Greenhorn

Joined: Oct 10, 2007
Posts: 10
Dear all,
I am facing a problem. I would like to know how to insert a xml value in the database using java program.

The sample code is given below :-


The code works fine with mysql, but when i am executing the same with postgresql, it gives me a error, like

Exception: Bad value for type long : hi dears
org.postgresql.util.PSQLException: Bad value for type long : hi dears
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toLong(AbstractJdbc2ResultSet.java:2736)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getLong(AbstractJdbc2ResultSet.java:2032)
at org.postgresql.jdbc3.Jdbc3ResultSet.getClob(Jdbc3ResultSet.java:43)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getClob(AbstractJdbc2ResultSet.java:386)
at MySqlClobSetClob.main(MySqlClobSetClob.java:36)



Awaiting the reply in this regards,


regards,

Sreejith Padmanabhan
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38003
    
  22
Difficult to tell. Where is the exception actually thrown from that method? What is hi dears which I can't seem to find in the method. I looked up PostgreSQL for data types here and couldn't find long.

I think we ned more information, please.
Sreejith Padmanabhan
Greenhorn

Joined: Oct 10, 2007
Posts: 10
hi dears is the value which comes from the xml file. the format of the xml file is like this

Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38003
    
  22
How do you get "hi dears" into a long?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Regarding insertion in postgresql
 
Similar Threads
how to set the beans object into an arraylist
resultset next() returns false and yet record(s) exist
which session listner to be impletement
Regarding insertion in postgresql
help me in improving performance of prepared statement