Meaningless Drivel is fun!*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 37907
    
  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: 37907
    
  22
How do you get "hi dears" into a long?
 
Don't get me started about those stupid light bulbs.
 
subject: Regarding insertion in postgresql
 
Similar Threads
how to set the beans object into an arraylist
which session listner to be impletement
Regarding insertion in postgresql
help me in improving performance of prepared statement
resultset next() returns false and yet record(s) exist