Sybase « Database « JPA Q&A





1. Recovery after Sybase DB crash    forum.hibernate.org

We have recently had a situation where our application has failed to handle a DB crash. When the DB restarted, the process successfully reconnected but kept having the following error (in the stack trace below) whenener it attepted to load/find objects from a join (eager fetch across objects). So it could do selects fine, but looked to be having trouble when ...

2. Recovery after Sybase DB crash    forum.hibernate.org

We have recently had a situation where our application has failed to handle a DB crash. When the DB restarted, the process successfully reconnected but kept having the following error (in the stack trace below) whenener it attepted to load/find objects from a join (eager fetch across objects). So it could do selects fine, but looked to be having trouble when ...

4. Sybase dialect : problem with "identity" when opti    forum.hibernate.org

Hi all, I have noticed and read on the URL below that two essential things in Sybase where incompatible: - the identity feature, allowing to generate id automatically - the "DYNAMIC PREPARE" option which enables the parsing & compilation of PreparedStatements (ultra mandatory to boost the execution of requests) If those two settings are enabled with the jConnect 5.5 driver for ...

5. how to point hibernate to a different db with in sybase?    forum.hibernate.org

Hi, I just got my hibernate working with my java object, but I couldn't specify which the database with in the sybase server, I am able to connect to the sybase database, and now I am having problem in pointing to a different database with in the sybase server. Does any one know how to look for a table in a ...

6. Sybase 12.5 dialect required    forum.hibernate.org

7. Sybase Dialect problem for smallint    forum.hibernate.org

hi , am using the following dialect "org.hibernate.dialect.SybaseDialect", There is a field in the database which is of type smallint.When i execute a query it returns the following exception eg ..input = 1 Implicit conversion from datatype 'VARCHAR' to 'SMALLINT' is not allowed. Use the CONVERT function to run this query. However the same query with the same input works on ...

8. Newbie question -- multiple databases in Sybase ASE    forum.hibernate.org

We're using Sybase Adaptive Server 12.5, and have development, testing and production databases on this server. I want to set up an application that will use any of these databases on an ad-hoc basis, and didn't see anything documented. I'm looking for any advice anyone can offer. The same tables exist in every database, and the mapping documents are all the ...