Skip to Content.
Sympa Menu

freetds - jdbc Linux sybase

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "nick bhanji" <nbhanji AT home.com>
  • To: freetds
  • Subject: jdbc Linux sybase
  • Date: Sun, 27 Jun 1999 22:54:55


Hello Again - I got further than before but I still have the same problem.
The problem is that when i run test t0001 i get the following error 1st
time:
[bhanji@serve unittests]$ java t0001
Starting test t0001- Insert and retrieve timestamps
AT POINT ONE <--- debugging code
AT POINT TWO
AT POINT 3
Creating table affected 0 rows
AT POINT 4
AT POINT 5
java.sql.SQLException: Logon failed. Msg 5703, Lvl 0, State 1, Changed
language setting to 'us_english'.
, Server , Procedure , Line 1
1 connection are in use by this program
at
com.internetcds.jdbc.tds.Connection.allocateTds(Connection.java:341)
at
com.internetcds.jdbc.tds.Connection.prepareStatement(Connection.java:500)
at t0001.main(t0001.java:51)

when I run it again:
[bhanji@serve unittests]$ java t0001
Starting test t0001- Insert and retrieve timestamps
AT POINT ONE
AT POINT TWO
AT POINT 3
Creating table affected 0 rows
AT POINT 4
AT POINT 5
AT POINT 6
AT POINT 7
AT POINT 8
AT POINT 9
AT POINT 10
AT POINT 11
java.sql.SQLWarning: Stored procedure 'sa.jdbc_gen_temp_sp_names' not
found. Specify owner.objectname or use sp_help to check whether the object
exists (sp_help may produce lots of output).

at
com.internetcds.jdbc.tds.SqlMessage.toSQLWarning(SqlMessage.java:80)
at
com.internetcds.jdbc.tds.Statement.getMoreResults(Statement.java:597)
at com.internetcds.jdbc.tds.Statement.execute(Statement.java:463)
at
com.internetcds.jdbc.tds.Tds.generateUniqueProcName(Tds.java:1883)
at
com.internetcds.jdbc.tds.Tds.getUniqueProcedureName(Tds.java:1947)
at
com.internetcds.jdbc.tds.PreparedStatement.execute(PreparedStatement.java:155)
at
com.internetcds.jdbc.tds.PreparedStatement.executeUpdate(PreparedStatement.java:345)
at t0001.main(t0001.java:62)


I traced this to TDS.class where temp stored proc is made and delivered to
DB. I have question, is there anywhere in TDS that login id and password
are not sent properly so that temp. procedure is not stored

Please HELP.

thank u in advance

nick.b





  • jdbc Linux sybase, nick bhanji, 06/27/1999

Archive powered by MHonArc 2.6.24.

Top of Page