Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 11-13-2008, 09:01 AM
Member
 
Join Date: Nov 2008
Posts: 15
Rep Power: 0
Nomad is on a distinguished road
Default Database and Sqlxml
Hi,

can anyone tell me why this shouldn't work
sqlxml = connection.createSQLXML();

with this

public class Main {

static final String DATABASE_URL = "jdbcdbc:crm";
private Connection connection;
private Statement statement;
private String LOGIN = "crm";
private String PSWD = "crm";
private int numberOfColomns;
private String query;
private SQLXML sqlxml;

public Main() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
connection = DriverManager.getConnection(DATABASE_URL, LOGIN, PSWD);
statement = connection.createStatement(ResultSet.TYPE_SCROLL_I NSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
sqlxml = connection.createSQLXML();

the only idea i have is that the database doesn't support xml but it's a simple access data base so it should be fine right

Exception in thread "main" java.lang.UnsupportedOperationException
at sun.jdbc.odbc.JdbcOdbcConnection.createSQLXML(Jdbc OdbcConnection.java:1821)
Bookmark Post in Technorati
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
textfield and database t3mh4 Database 2 05-14-2008 09:12 AM
H2 Database Engine 1.0.71 Java Tip Java Announcements 0 04-26-2008 09:28 PM
Database to JApplet Preethi New To Java 0 03-26-2008 06:18 AM
H2 Database Engine 1.0.68 JavaBean Java Announcements 0 03-16-2008 09:42 PM
Database in a PDA percivalwcy Database 2 08-08-2007 04:10 AM


All times are GMT +2. The time now is 06:06 AM.



VBulletin, Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2009, Crawlability, Inc.
Copyright ©2006 - 2007, www.java-forums.org