sybase « sybase « Java Database Q&A





1. How best can I isolate my application from an unreliable database?    stackoverflow.com

I have a Java SOAP data service which sits on top of a Sybase database which, for reasons out of my control, has unreliable performance. The database is part of a ...

2. Performance differences between jconn2 and jconn3    stackoverflow.com

I have tested jconn2 and jconn3 on same application which is connected to sybase ase15.03 server . But I encountered the really big performance differences between these two api. For example ...

3. Java and Sybase    stackoverflow.com

What is the difference between the drivers provided using jtds.jar and jconn3.jar?

4. A tool that can detect redundant database tables    stackoverflow.com

I'd like to find a tool that can detect redundant/unused tables and stored procedures in a sybase database. The DB is accessed from a Java application which uses JDBC to access both ...

5. How do you LOAD TABLE in Sybase IQ from a client using Java?    stackoverflow.com

Is it possible to load a file from a client computer into a table in Sybase IQ, using the LOAD TABLE ... USING CLIENT FILE statement? The data does not come from ...

6. Does sybase 15 support the bcp api in java?    stackoverflow.com

A long time ago I figured out that bcp is just a little C program that calls the special bit of the sybase client api to do mass data moving into ...

7. Writing Big XML in sybase and reading it?    stackoverflow.com

I am inserting a vey big xml in the Sybase column which has type 'text'. I am writing it using setString in PreparedStatement and reading it using getString. But when I select it ...

8. How to debug transaction commit in sybase?    stackoverflow.com

I have a transaction based application and it rolls the operation back on an error. However in some cases, the rollback doesn't happen. ( Though its getting called from the application). ...

9. Creating WebApplication with Database Access in Java    stackoverflow.com

I have to create a simple WebApplication with Java which shows a Login Dialog and after it shows some textfields, gets some Data out of a Database (Sybase) do something with ...





10. Sybase Session Aborted Error    coderanch.com

Hello. I am writing a logging application which among other things checks for processes running on specific ports. I check to see if the port is avaliable or not based on wheather I can make a socket connection to the port without recieving any exceptions. The Sybase database connector is listening on port 4005 and when I check to see if ...

11. updatable recordsets in SYBASE    coderanch.com

Hi I used version jConnect 5.2 (I notice out timestamps are pretty close here.. it's like JavaRanch Chat).. I just found this on JDBC Tutorial on Sun (advanced section) Statement stmt = con.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); ResultSet srs = stmt.executeQuery("SELECT OF_NAME, PRICE FROM COFFEES"); This code is similar to what you have used earlier, except that it adds two arguments to the ...

12. Help on Sybase    coderanch.com

i am working on WebSphere 3.5 with Sybase Adaptive Server Anywhere 6.0 as the backend.I am using jconnect 5.2 jdbc driver.Could you please help me with my following queries: 1)I have to run two ASA databases on the same machine .and i want a servlet to connect to both these databases simultaneously for ex: a servlet reads data from one db ...

13. How to load image into Sybase database    coderanch.com

15. Calling all Sybase Gurus. . . Please help!    coderanch.com

I am developing a jsp intranet site to communicate with Sybase 12.0. I have an assumption that I need verified. If I perform a stored procedure and it fails, will Sybase throw a SQLException in all cases? Assume that the stored procedure never returns a user-defined return code. I need to determine if I will ever need to look at the ...





17. Problem in using JDO with Sybase - URGENT!!!    coderanch.com

Hi, We are using Sybase Evaluation Database along with JDO. While inserting data, sometimes we face following errors. The exception that we get ::: ******************************* NestedException: com.sybase.jdbc.SybSQLException: ASA Error -131: Syntax error near ' ' FailedObjectArray: [com.eq.smile.models.Exercise@1050be] at com.sun.forte4j.persistence.internal.runtime.core.SqlStore.executeSql (SqlStore.java:741) at com.sun.forte4j.persistence.internal.runtime.core.SqlStore.update(SqlStore.java:2085)at com.sun.forte4j.persistence.internal.runtime.core.SqlStore.execute(SqlStore.java:424) at com.sun.forte4j.persistence.internal.runtime.core.SqlStateManager.updatePersistent SqlStateManager.java:885) at com.sun.forte4j.persistence.internal.runtime.jdo.PersistenceManagerImpl.beforeCompletion PersistenceManagerImpl.java:805) at com.sun.forte4j.persistence.internal.runtime.jdo.PersistenceManagerImpl.internalFlush (PersistenceManagerImpl.java:1209) at com.sun.forte4j.persistence.internal.query.QueryImpl.flush(QueryImpl.java:459) at com.sun.forte4j.persistence.internal.query.QueryImpl.execute(QueryImpl.java:336) ******************************* From the Help Documentation ...

18. JDBC for Sybase    coderanch.com

19. alternatives to JDBC for Sybase.???    coderanch.com

Hello All, I'm trying to write an application running on windows NT workstation to connect to Sybase SQL server running on Solaris. I'm not permitted to make any changes to the SQL server.....can JDBC be implemented from the client side only??? I don't think there are any JDBC drivers loaded on the SQL server. Do all type 4 drivers (jconnect for ...

20. sybase related jdbc question    coderanch.com

21. JDBC and Sybase    coderanch.com

23. Java and Sybase    coderanch.com

Hi, In my project for the development of the new module, SYBASE is the database that is being used. Since this is going to be my first SYBASE project, I have a doubt about the "jdbc driver" for SYBASE. Once we install Oracle client in our machines, the classes12.zip file comes along with Oracle installation. Similiarly will the SYBASE driver be ...

25. Sybase - InstantDb : are they the same?    coderanch.com

26. com.sybase.jdbc2. jdbc. SybSQLException    coderanch.com

It means your log space is not enough to hold your transaction. Use dump transaction to clear the inactive log. However, if you job is too big. You have to either increase your log space or chop transaction into smaller pieces. Check sybase manual for transation log space management. It has nothing to do with JDBC.

27. Probs with Sybase    coderanch.com

Hi all, I am connecting to Sybase db using the JConnect JDBC driver. But when I fire a query for getting data from a column and the column is blank,then it returns " "(a string of length 1). If I check for this column on the REsultSet object using the wasNull(),the it still says false. My appln needs to work on ...

28. Sybase issue    coderanch.com

Hi, I am having Sybase as my backend. When I am inserting to table with a image column which basically stores a large string and the string to be inserted is of length 0,then it thron this exception, java.sql.SQLException: JZ0C0: Connection is already closed. at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:498) at com.sybase.jdbc2.jdbc.SybConnection.checkConnection(SybConnection.jav a:1619) at com.sybase.jdbc2.jdbc.SybStatement.checkDead(SybStatement.java:1717) at com.sybase.jdbc2.jdbc.SybPreparedStatement.setString(SybPreparedState ment.java:249) I run my code on Oracle and ...

29. doubt in sybase    coderanch.com

30. sybase    coderanch.com

31. with Java: how to update a row in sybase with string having a single quote    coderanch.com

Originally posted by sri pat: Actually I am executing a stored procedure(huge) with several parameters getting dynamically as part of the SQL. Do I need to change the stored procedure all the way(variables to ? marks) or is there anyway I can change the input parameters which I am passing dynamically. Just to be clear, you don't need to change the ...

32. JDBC for Sybase    coderanch.com

34. Sybase problem    coderanch.com

Hi, I am using jconn2 5.5 to connect to Sybase backend. I have a ConnectionPool in my appln code, with apis like getConnection() and releaseConnection(), which releases the connection back in the pool. At my side this works fine, but we have a clint site problem when suddenly a connection close happens (I dont think this happens tohrough my code as ...

35. How to handle RAISEERROR in Sybase using JDBC    coderanch.com

Hi Guys, I am trying to access a Sybase stored procedure thru JDBC where that Procedure has many debug messages using "RAISEERROR 22000". Ex: [ select @str = "You are in the first line of the procedure" RAISEERROR 22000 @str .....] When I am trying to call the SP using Callable statement the control is comingout as soon as it encountering ...

36. Secure JDBC - Sybase    coderanch.com

Hi, Sure this has been covered somewhere but dont seem to be able to find a concise answer. Our app is using straight JDBC connections to a database and some concern has been expressed that when we issue DriverManager.getConnection(dataBaseURL, userName, password) that the username/password is being passed across the wire in an unsecure fashion. The backend is Sybase and we are ...

37. Sybase Error Msg    coderanch.com

Hello, Can anyone please help me out below is the stored procedure and error. ============================================ Create Procedure spGetMaximumVersionForid @id int As Select id,Version = IsNull(Max(Ver),0) From ( Select id,Ver = Max(Version) From ModifiedForm Group By id Union Select id,Ver = Max(Version) From ReqForm Group By id ) As DT Where id= @id Group By id GO ================================= Server Message: Number 156, ...

38. Storing Object of a class in Sybase    coderanch.com

I am trying to store an Object of a class in sybase, how can I do that and how can I retieve that too. The issue over here is, I am getting messages really fast, the messages are nothing but Objects of some class, I dont have opportunity to process them and then acknowledge them. To acknowledge them I need to ...

39. Identity feild in Sybase.    coderanch.com

Hi all, I am using Syabseand I have a table that contains one feild set as employee_id numeric(10,0) IDENTITY I need ti update a record to this table with my own empoloyee_id,it will works only after when execute this command set IDENTITY_INSERT employee_tbl on That is ok and i insert the row.But i need to update the employee id of one ...

41. Sybase SP error - Operand type clash: INT is incompatible with DATETIME    coderanch.com

Hi, I am calling a sybase SP from my application like following: conn = getSybaseConnection(); procName = " testschema.PlaceOrder"; procStmt = "{?=CALL " + procName + "( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ...

42. Precision problem in Sybase    coderanch.com

43. Statement.getGeneratedKeys() with Sybase not working    coderanch.com

Just as a side note, getGeneratedKeys() is *not* supported by all JDBC drivers... ...One common solution in large enough systems (where concurrency is paramount) is to not use keys generated by the database. I'm thinking of doing away with auto-generated keys and using a trigger instead. For example, my inventory item record could have a field called ITEM_CODE instead of an ...

44. Problem with Java and Sybase    coderanch.com

Bruno, I don't think Scott meant you were doing it the wrong way in Eclipse. I think he wanted to know how you were doing it in Eclipse because he didn't know of any way to do it. I might be wrong about that, but I think I'm right because I don't know how you use Eclipse to do it either. ...

45. Sybase beginner, Need Help    coderanch.com

46. Storing Object of a class in Sybase(Posted in JDBC Saloon also)    coderanch.com

Hi All Gurus, I posted this one in JDBC forum but didnt get much response, so reposting here too. I this causes any inconvenience, please accept my apologies. I am trying to store a java Object of a class in sybase, how can I do that and how can I retieve that too. The issue over here is, I am getting ...

47. Java Sybase -->Arithmetic overflow    coderanch.com

Hi fellow ranchers, my application tries to insert data into sybase database.I use the JDBC preparedstatement.It is a simple insert query. One of the fields is field1 which is defined as Numeric(38,14) in database.But i get the error when i call the preparedstatement.executeUpdate(); ----------------------------------------------------------------- com.sybase.jdbc2.jdbc.SybSQLException: Arithmetic overflow during implicit conversion of FLOAT value '6778.6700000000001' to a NUMERIC field . ----------------------------------------------------------------- The ...

48. callable statement question with sybase    coderanch.com

Hello guys: I have a alter procedure in sqlanywhere as following: ALTER PROCEDURE "DBA"."spGetAverageList"( IN tstStartTime TIMESTAMP, IN tstEndTime TIMESTAMP, IN intPointCount INT, IN strFieldName VARCHAR(100) ) RESULT (fldTimeStamp TIMESTAMP, decAverage DECIMAL(8,2)) BEGIN DECLARE tstIntervalBegin TIMESTAMP; DECLARE tstIntervalEnd TIMESTAMP; DECLARE intTimeDiff INT; DECLARE intStepLength INT; DECLARE intCountIndex INT; DECLARE decAverageValue DECIMAL(8,2); DECLARE intTempValue int; DECLARE tstAverageTime TIMESTAMP; DECLARE intAverageTimeDiff INT; DECLARE ...

52. Sybase ASE 12.5 : getString()    dbforums.com

54. Accessing Sybase's @@identity problem    dbforums.com

We're using dummy tables for storing autonumeric data (identity fields) so we're aware the way to access and retrieve those autonumerics: insert into dummy_table values () select @@identity The first part is working quite good... just an insert but we're having a bad time with the second (select @@identty). We ALWAYS get a SQLException (Result set IDLE, not currently accessing a ...

55. Precision problem in Sybase    forums.oracle.com

56. sybase database    forums.oracle.com