File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes SQLXML type Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQLXML type " Watch "SQLXML type " New topic
Author

SQLXML type

Padmanabh Sahasrabudhe
Ranch Hand

Joined: Mar 04, 2008
Posts: 53
I want to use the SQLXML type and I am using a available sample. I get the following error when I try to create SQLXML:



The stacktrace I get is:
java.sql.SQLException: Unsupported feature
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)
at oracle.jdbc.driver.DatabaseError.throwUnsupportedFeatureSqlException(DatabaseError.java:765)

The information about the driver is:
DatabaseProductName: Oracle
DatabaseProductVersion: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
DatabaseMajorVersion: 10
DatabaseMinorVersion: 1
===== Driver info =====
DriverName: Oracle JDBC driver
DriverVersion: 11.1.0.7.0-Production
DriverMajorVersion: 11
DriverMinorVersion: 1
===== JDBC/DB attributes =====
Supports getGeneratedKeys(): true
Padmanabh Sahasrabudhe
Ranch Hand

Joined: Mar 04, 2008
Posts: 53
Sorry the full Stacktrace is:
Supports getGeneratedKeys(): true
java.sql.SQLException: Unsupported feature
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)
at oracle.jdbc.driver.DatabaseError.throwUnsupportedFeatureSqlException(DatabaseError.java:765)
at oracle.jdbc.driver.PhysicalConnection.createSQLXML(PhysicalConnection.java:8893)
at my.SQLXMLType.storeXMLDocument(SQLXMLType.java:58)
at my.SQLXMLType.getSQLXML(SQLXMLType.java:134)
at my.SQLXMLType.main(SQLXMLType.java:51)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQLXML type
 
Similar Threads
SQLXML problem
Connection to database Exception
JDBC Connection (or "I Am At My Wits End")
New to JDBC - problems
Exception while connecting to an Oracle database