Creator 2 3rd party DB Driver Support

Creator ships with DB drivers that we support.  Recent MySQL drivers are also supported.


But what about other drivers?


Here's how to determine if your driver works:


Add a datasource using your driver and database.  See the Tutorials page for  Creating Database Server Types and Data Sources.


In the servers pane, open up your data source node and see if you can see any tables.


If that works, pick a double and double click to "View Data".  Now alter the query, prefixing it with "smd " (this is an undocumented command).  E.g., "smd select \* from myTable".  Run.


This creates a PreparedStatement for the given SQL and outputs the ResultSet from the preparedStatement.getMetaData() call.


If data is displayed, does it look "reasonable"?   Most important are the ColumnName and Type columns.  For a valid example, compare it to data from a supported driver (e.g., a table in our bundled database).


Does it throw an exception?  If so, it's not supported and will not work at design time.  Period. 


All the failures I've seen so far are because PreparedStatement.getMetaData() does not work, usually throwing a "not supported" exception.  Some drivers support this call after statement execution, but we require support before executing the statement.


Add a comment to this entry with the driver/database that you'd like to see supported.  Even if someone else has mentioned your database, comment yourself.  Supporting additional drivers is on the unfinalized list of features for next release (no promises!).

Comments:

I would appreciate if you consider to support jconn2.jar/adaptive server anywhere (from sybase) to work with Studio Creator

Posted by Laura Esther Rodriguez Diaz on January 26, 2006 at 06:53 AM PST #

Please please support Oracle JDBC. Pretty amazing its not in there for starters...By this I mean specifically using with tables.

Posted by Paulo on February 07, 2006 at 10:48 PM PST #

This is painful, we have applications from 20 years of corp. life. I want to pull things forward, based on Java Technology. But the lack of the odbc bridge working makes the whole thing a non-starter. The first application I tried, is to do a "gui" for a microsoft access database. Its a real-time application, and its placing the data in a access database. I have found two issues: Other JAVA applications, such as DBVisualizer work fine with the database, and the DSN etc, so thats not a problem. Studio Creator 2 seems to see all the tables in the file, and most of the elements look reasoable, but all the accesses come back with result set closed. Help me, before I have to give up, I like the rest of what I see to much.

Posted by Glenn West on March 15, 2006 at 12:00 PM PST #

Post a Comment:
Comments are closed for this entry.
About

jfbrown

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today
News
Blogroll

No bookmarks in folder