• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Regarding insertion in postgresql

 
Sreejith Padmanabhan
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 49823
69
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi dears is the value which comes from the xml file. the format of the xml file is like this

 
Campbell Ritchie
Sheriff
Pie
Posts: 49823
69
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How do you get "hi dears" into a long?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic