SQLXML problem

[loganathan kalyan]

Can anyone help me?
i tried to store xml into oracle using xmlsql. When i tried to create instance for the SQLXML using connection.createSQLXML(), i got the "Exception in thread "main" java.lang.AbstractMethodError: oracle.jdbc.driver.T4CConnection.createSQLXML()Ljava/sql/SQLXML;"

could you please let me know why this exception happend?

Thanks in advance,

Loganathan.k

[Jan Cumps]

You are using functionality that is only introduced in Java 1.6. Does your jdbc driver support it?

[ujjwal soni]

Hi,

It seems to be an issue with the jdbc type driver you are using. The SQLXML data type provides a database-to-Java mapping facility for database type XML. You can use the SQLXML data type with any database that supports the XML data type, and provides a JDBC 4.0 driver. Vendor-specific XML-to-SQL APIs are not required with SQLXML. The SQLXML API is included in JDK 6.0. DB2 9 supports the XML data type. IBM Data Server Driver for JDBC and SQLJ Version 4.0 is the JDBC 4.0 driver for DB2 9 database.

[loganathan kalyan]

Jan Cumps wrote:You are using functionality that is only introduced in Java 1.6. Does your jdbc driver support it?

Yes i am using ojdbc6.jar

[Campbell Ritchie]

Have you read about it in the API documents?

[Jan Cumps]

loganathan kalyan wrote:Yes i am using ojdbc6.jar

But that driver supports it. Can you check your classpath to see if you have older oracle jdbc drivers in it?

[loganathan kalyan]

Jan Cumps wrote:

loganathan kalyan wrote:Yes i am using ojdbc6.jar

But that driver supports it. Can you check your classpath to see if you have older oracle jdbc drivers in it?

Campbell now that problem is solved but now i am getting "UnsupportedFeatureSqlException". Thanks for your effort


Thanks

Loganathan

[Campbell Ritchie]

And what are the details of that Exception?

[loganathan kalyan]

Campbell Ritchie wrote:And what are the details of that Exception?

here is the details:
java.sql.SQLException: サポートされない機能です。
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:403)
at oracle.jdbc.driver.DatabaseError.throwUnsupportedFeatureSqlException(DatabaseError.java:702)
at oracle.jdbc.driver.PhysicalConnection.createSQLXML(PhysicalConnection.java:8764)
at SqlXmlDemo.loadDemoData(SqlXmlDemo.java:93)
at SqlXmlDemo.main(SqlXmlDemo.java:142)

サポートされない機能です。 ------> unsupported operation( i am using japanese os thats why)


Nb: i am using oracle10.2.0.3.0

[Padmanabh Sahasrabudhe]

Were you able to[ resolve the issue? I am getting the same issue:
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 tests.functional.cartridge.java.common.apps.java_cartridge.SQLXMLType.storeXMLDocument(SQLXMLType.java:56)
at tests.functional.cartridge.java.common.apps.java_cartridge.SQLXMLType.getSQLXML(SQLXMLType.java:125)
at tests.functional.cartridge.java.common.apps.java_cartridge.SQLXMLType.main(SQLXMLType.java:49)

[suji Panneer]

Hi

Even i am getting the error,please anyone knows how to rectify this.

java.sql.SQLException: Unsupported feature
Exception in thread "main" java.sql.SQLException: Unsupported feature
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.ja
va:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:1
33)
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 TestSQL.prepareCall(TestSQL.java:47)
at TestSQL.main(TestSQL.java:132)