Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[bug] setAutoCommit(boolean) of Connection

5 views
Skip to first unread message

강신동

unread,
May 13, 1999, 3:00:00 AM5/13/99
to

Hi

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.


Daniel Montero

unread,
May 13, 1999, 3:00:00 AM5/13/99
to

jConnect 5.0 works with JDK 1.2 (Java2)
in order to get metadata working, you have to run the script under the
$JDBC_HOME/sp/ directory in your Adaptive Server. There are two scripts, one
for ASEnterprise and another for ASAnywhere. Choose the appropiate one. This
will create some special stored procedures in your server that are used by
jConnect.
HTH

Dave Stampf

unread,
May 26, 1999, 3:00:00 AM5/26/99
to
Hi,

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.---

0 new messages