Max,
The only code is related to the reference I provided to JDBCBinder.java. I don't know where Hibernate Tools is initializing the JDBC driver - perhaps it's being configured in a strange way. Again, I can get meta data by writing my own Java program - but it fails through Hibernate Tools.
Here is the test program I wrote:
----------------------------------------------------------------------------------------
import java.sql.*;
public class TestJDBCDriver {
public static void main(String[] args) {
String url = "jdbc:jtds:sybase://scsefpsddb01:5001;user=eqprod1;password=deriv8tives";
try {
Class.forName("net.sourceforge.jtds.jdbc.Driver");
Connection conn = DriverManager.getConnection(url, "eqprod1", "deriv8tives");
DatabaseMetaData meta = conn.getMetaData();
ResultSet res = meta.getTables(null, null, "hts_sec_master", null);
while (res.next()) {
String tableName = res.getString("TABLE_NAME");
String schemaName = res.getString("TABLE_SCHEM");
String catalogName = res.getString("TABLE_CAT");
ResultSet cres = meta.getColumns(catalogName, schemaName, tableName, null);
while (cres.next()) {
int sqlType = cres.getInt("DATA_TYPE");
String sqlTypeName = cres.getString("TYPE_NAME");
String columnName = cres.getString("COLUMN_NAME");
String columnDefaultValue = cres.getString("COLUMN_DEF");
// if columnNoNulls or columnNullableUnknown assume "not nullable"
boolean isNullable = (DatabaseMetaData.columnNullable == cres.getInt("NULLABLE"));
int size = cres.getInt("COLUMN_SIZE");
int decimalDigits = cres.getInt("DECIMAL_DIGITS");
System.out.println("Column info:");
System.out.println("/tName: "+columnName);
}
}
} catch(Exception e) {
e.printStackTrace();
}
}
}
-------------------------------------------------------------------------------------
Here's my Hibernate configuration, hibernate.cfg.xml:
-------------------------------------------------------------------------------------
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
<property name="connection.url">jdbc:jtds:sybase://scsefpsddb01:5001;user=eqprod1;password=deriv8tives</property>
<property name="connection.username">eqprod1</property>
<property name="connection.password">deriv8tives</property>
<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>
<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.Sybase11Dialect</property>
<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>
</session-factory>
</hibernate-configuration>
-------------------------------------------------------------------------------------
Login
FAQ
Search
