This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes SQLXML problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQLXML problem" Watch "SQLXML problem" New topic
Author

SQLXML problem

loganathan kalyan
Greenhorn

Joined: Apr 24, 2009
Posts: 7
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


Loganathan.K
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2491
    
    8

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


OCUP UML fundamental and ITIL foundation
youtube channel
ujjwal soni
Ranch Hand

Joined: Mar 28, 2007
Posts: 403
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.


Cheers!!!
Ujjwal B Soni <baroda, gujarat, india> <+919909981973>
"Helping hands are better than praying lips......"
loganathan kalyan
Greenhorn

Joined: Apr 24, 2009
Posts: 7
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

Joined: Oct 13, 2005
Posts: 37900
    
  22
Have you read about it in the API documents?
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2491
    
    8

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

Joined: Apr 24, 2009
Posts: 7
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

Joined: Oct 13, 2005
Posts: 37900
    
  22
And what are the details of that Exception?
loganathan kalyan
Greenhorn

Joined: Apr 24, 2009
Posts: 7
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

Joined: Mar 04, 2008
Posts: 53
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

Joined: Feb 17, 2010
Posts: 1
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)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQLXML problem
 
Similar Threads
Someone please help me with the traceroute using jpcap
Java version of sqlxml
SQLXML type
Connection, Resultset and statement
Replacement for SQLXML