I downloaded 1999 year, may, 13th .
jConnect 5.0 trial version
String driver = "com.sybase.jdbc2.jdbc.SybDriver";
Class.forName(driver);
Connection con = DriverManager.getConnection(url, p);
con.setAutoCommit(false);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from test");
rs.next();
System.out.println(rs.getString("name"));
rs.close();
stmt.close();
con.close();
compiling success.
Excuting environment is windows 95 (jdk1.1.7b),
and sunOS 5.6(JDK 1.2 beta),
I tested jConnect 5.0 which downloaded just now .
previous version of jConnect 5.0 run very well at setAutoCommit(boolean
auto) from java.sql.Connection.
java.sql.SQLException: JZ0SJ: can not find metadata access information
from database
at
com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:418)
at com.sybase.jdbc2.jdbc.MdaManager.loadMetaData(Compiled Code)
at com.sybase.jdbc2.jdbc.MdaManager.loadMetaData(Compiled Code)
at com.sybase.jdbc2.jdbc.MdaManager.<init>(MdaManager.java:135)
at com.sybase.jdbc2.jdbc.MdaManager.<init>(MdaManager.java:120)
at
com.sybase.jdbc2.jdbc.SybConnection.checkMDA(SybConnection.java:1205)
at
com.sybase.jdbc2.jdbc.SybConnection.getMDA(SybConnection.java:1149)
at com.sybase.jdbc2.tds.Tds.setOption(Tds.java:745)
at
com.sybase.jdbc2.jdbc.SybConnection.setAutoCommit(SybConnection.java:458)
at shindong.sql.SybaseBasic.main(SybaseBasic.java:18)
please, debug above.
Let me know that your answer.
Thanks for my report.
I've installed jConnect on a Sun system and there is no sp directory.
Can anyone point to where this script might be found? I've also seen it
referred to the sp_mda script, but I cannot locate that either.
thanks!
Dave
In article <373B0201...@sybase.com.mx>,
--
Dave Stampf
Brookhaven National Lab
Upton NY 11973
d...@bnl.gov
--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---