Gunnar R|nning <[EMAIL PROTECTED]> wrote:
> jon * <[EMAIL PROTECTED]> writes:
>
> > Sybase/SQLServer (they are essentially the same) are two very f*cked up
> > databases with bad JDBC drivers that don't fully implement the JDBC spec.
> > :-(
>
> What parts of the JDBC spec are not supported by which JDBC drivers ? I've
> been happily using the JConnect for Sybase in two projects(around 300K
> lines of code combined) and have only run into minor problems and bugs that
> have been fixed promptly by the excellent support at Sybase.
Sybase's JConnect doesn't implement some of the ResultSetMetadata methods of
the JDBC spec. They are listed in the readme/release notes for each version.
After searching the jconnect forums, an engineer said that the getTableName()
method ( which is what is stopping village from working ) is slated for v12.5
of sybase. This fix requires the TDS stream to change and thus a change in
all sybase products. We are in the same boat, stuck with Sybase and no
ability to change. So until this is resolved we need a different db for
turbine/village, or do like I did and extend turbine to use our own
authentication/authorization for turbine apps and not be dependant on a db (
which is very nicely designed in turbine ).
Jconnect v4.2/5.2
------------------
6.1 JDBC 1.0 Standard Methods Implementation
These JDBC 1.0 standard methods are not implemented and generate a SQL
exception when used:
ResultSetMetaData.getSchemaName()
ResultSetMetaData.getTableName() (implemented only for text and
image datatypes)
ResultSetMetaData.getCatalogName()
6.2 JDBC 2.0 Standard Methods Implementation
The following table lists the JDBC 2.0 standard methods that have not been
implemented. JDBC 2.0 standard
methods that do not appear in this table, have been implemented for only
jConnect 5.0 and 5.2.
Interface
Method Signature
CallableStatement
Array getArray(int) Blob getBlob(int) Clob getClob(int)
Object getObject(int,
java.util.Map) Ref getRef(int)
Connection
java.util.Map getTypeMap() void setTypeMap(java.util.Map)
DatabaseMetaData
ResultSet getUDTs(String, String, String, int[])
PreparedStatement
void setArray(int, Array) void setBlob(int, Blob) void
setClob(int, Clob) void
setRef(int, Ref)
ResultSet
Array getArray(int) Array getArray(String) Blob
getBlob(int) Blob getBlob(String)
Clob getClob(int) Clob getClob(String) Object
getObject(int, java.util.Map) Object
getObject(String, java.util.Map) Ref getRef(int) Ref
getRef(String)
Statement
void setFetchdirection(int)
Jconnect 4.1/5.0
----------------
JDBC 1.0 Standard Methods Implementation
These JDBC 1.0 standard methods are not implemented and generate a
SQL exception when used:
ResultSetMetaData.getSchemaName()
ResultSetMetaData.getTableName()
ResultSetMetaData.getCatalogName()
DBC 2.0 Standard Methods Implementation
The following table lists the JDBC 2.0 standard methods that have not
been implemented. JDBC 2.0 standard methods that do not appear
in this table, have been implemented only for jConnect 5.0.
Interface
Method Signature
CallableStatement
Array getArray(int)
Blob getBlob(int)
Clob getClob(int)
Object getObject(int, java.util.Map)
Ref getRef(int)
Connection
java.util.Map getTypeMap()
void setTypeMap(java.util.Map)
DatabaseMetaData
ResultSet getUDTs(String, String, String, int[])
PreparedStatement
void setArray(int, Array)
void setBlob(int, Blob)
void setClob(int, Clob)
void setRef(int, Ref)
ResultSet
Array getArray(int)
Array getArray(String)
Blob getBlob(int)
Blob getBlob(String)
Clob getClob(int)
Clob getClob(String)
Object getObject(int, java.util.Map)
Object getObject(String, java.util.Map)
Ref getRef(int)
Ref getRef(String)
Statement
void setFetchdirection(int)
Jeffrey D. Brekke
mailto:[EMAIL PROTECTED]
http://sites.netscape.net/ekkerbj/homepage
____________________________________________________________________
Get your own FREE, personal Netscape WebMail account today at
http://webmail.netscape.com.
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
