aspose file tools*
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: 39869
    
  28
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: 39869
    
  28
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