Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQLXML problem

 
loganathan kalyan
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 2588
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You are using functionality that is only introduced in Java 1.6. Does your jdbc driver support it?
 
ujjwal soni
Ranch Hand
Posts: 403
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 48921
58
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you read about it in the API documents?
 
Jan Cumps
Bartender
Posts: 2588
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 48921
58
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
And what are the details of that Exception?
 
loganathan kalyan
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 53
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic