Advertisement
Guest User

Untitled

a guest
Mar 16th, 2016
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.87 KB | None | 0 0
  1. DROP TABLE xml_docs;
  2. CREATE TABLE xml_docs(
  3. id serial PRIMARY KEY,
  4. cad_number character(50),
  5. gkuzu_name character(50),
  6. gkuzu xml,
  7. rreq_name character(50),
  8. rreq xml
  9. )
  10.  
  11. String sql = "INSERT INTO xml_docs(cad_number,gkuzu_name,gkuzu,rreq_name,rreq) VALUES(?,?,?,?,?)";
  12. PreparedStatement stmt = ce.prepareStatement(sql);
  13. stmt.setString(1, "11:33:5464563");
  14. stmt.setString(2, xml_gkuzu.getName());
  15. stmt.setString(3, xml_gkuzu.toString());
  16. stmt.setString(4, xml_rreq.getName());
  17. stmt.setString(5, xml_rreq.toString());
  18. stmt.executeQuery();
  19. ce.close();
  20. se.close();
  21.  
  22. Exception in thread "main" org.postgresql.util.PSQLException: ERROR: column "gkuzu" is of type xml but expression is of type character varying
  23. Подсказка: You will need to rewrite or cast the expression.
  24.  
  25. String sql1 = "INSERT INTO xml_docs(cad_number,gkuzu_name,gkuzu,rreq_name,rreq) VALUES(11335464563,"+xml_gkuzu.getName()+",XMLPARSE("+xml_gkuzu.toString()+"),"+xml_rreq.getName()+",XMLPARSE("+xml_rreq.toString()+"))";
  26.  
  27. Exception in thread "main" org.postgresql.util.PSQLException: ERROR: syntax error at or near "bf48e000b0"
  28.  
  29. INSERT INTO xml_docs(id, gkuzu) VALUES (1, XMLPARSE('<foo><bar>Hello</bar></foo>'));
  30.  
  31. String sql = "INSERT INTO xml_docs(id, gkuzu) VALUES (?, XMLPARSE(?))";
  32. [...]
  33. stmt.setString(2, "<foo>Hello World!</foo>");
  34.  
  35. INSERT INTO xml_docs(id, gkuzu) VALUES (1, XMLPARSE('<foo>Hello World!</foo>'));
  36.  
  37. String xml = xml_gkuzu.toString();
  38.  
  39. SQLXML sqlxml = connection.createSQLXML();
  40. sqlxml.setString(xml);
  41. stmt.setSQLXML(3, sqlxml);
  42.  
  43. jdbc:postgresql://localhost/test?stringtype=unspecified
  44. or
  45. jdbc:postgresql://localhost/test?user=user&password=pass&stringtype=unspecified
  46.  
  47. String sql = "INSERT INTO xml_docs(id, gkuzu) VALUES (?, XML(?))";
  48. [...]
  49. stmt.setString(2, "<foo>Hello World!</foo>");
  50.  
  51. INSERT INTO xml_docs(id, gkuzu) VALUES (1, XML('<foo>Hello World!</foo>'));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement