1. How best can I isolate my application from an unreliable database? stackoverflow.comI 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.comI 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.comWhat is the difference between the drivers provided using jtds.jar and jconn3.jar? |
4. A tool that can detect redundant database tables stackoverflow.comI'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.comIs 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.comA 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.comI 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.comI 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.comI 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.comHello. 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.comHi 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.comi 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 |
14. Updatable AND Scrollable Recordsets in Sybase coderanch.com |
15. Calling all Sybase Gurus. . . Please help! coderanch.comI 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 ... |
16. how to retrieve data from Sybase text datatype?? coderanch.com |
17. Problem in using JDO with Sybase - URGENT!!! coderanch.comHi, 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.comHello 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 |
22. creating table in MS-Access table from sybase database coderanch.com |
23. Java and Sybase coderanch.comHi, 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 ... |
24. Problems with Callable Statement in Sybase coderanch.com |
25. Sybase - InstantDb : are they the same? coderanch.com |
26. com.sybase.jdbc2. jdbc. SybSQLException coderanch.comIt 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.comHi 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.comHi, 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.comOriginally 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 |
33. sybase database turns to be very slow after Solaris system is rebooted coderanch.com |
34. Sybase problem coderanch.comHi, 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.comHi 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.comHi, 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.comHello, 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.comI 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.comHi 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 ... |
40. How to catch sybase raiseerror in java ? coderanch.com |
41. Sybase SP error - Operand type clash: INT is incompatible with DATETIME coderanch.comHi, 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.comJust 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.comBruno, 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.comHi 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.comHi 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.comHello 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 ... |
49. Special Character Issues in Java with Sybase coderanch.com |
50. How to read a '\n; new line character from Sybase DB ? coderanch.com |
52. Sybase ASE 12.5 : getString() dbforums.com |
53. Sybase + Java com.sybase.jdbc2.jdbc.SybSQLWarning: dos dbforums.com |
54. Accessing Sybase's @@identity problem dbforums.comWe'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 |