user c3p0 connection sybase any where 12 DB, The following statement has been run ALTER DATABASE UPGRADE JCONNECT ON; The error is as follows: ~ SQL Error: 0, SQLState: JZ0SJ ERROR ~ JZ0SJ: Metadata accessor information was not found on this database. Please install the required tables as mentioned in the jConnect documentation. javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not insert: [models.LatoCatalog] at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1214) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1147) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1153) at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:678) at play.db.jpa.JPABase._save(JPABase.java:37) at play.db.jpa.GenericModel.save(GenericModel.java:184) The problems encountered were the same as those in the web site, but no solution was found link the same ERROR (Http://lists.jboss.org/pipermail/hibernate-issues/2009-August/016491.html) |
Did the ALTER DATABASE UPGRADE JCONNECT ON display any error messages?
...or is the ERROR ~ JZ0SJ coming from the ALTER?
Do you have this file? It is part of the SQL Anywhere 12 installation: C:\Program Files\SQL Anywhere 12\Bin64\dbscript12.dll
You need an SAP "s-user id" to do downloads.
Is that the whole error stack?
Are there any "Caused by" entries in the stack?
The application software environment is as follows:
c3p0 +Hibernate (ver 3.6) +jtds(ver 1.3.1) +sa(12 or 17)
Ability to create new tables and columns, but cannot insert data , insert errors after inserting data.
The problem with the SA17 version remains
There is no error in running the following statement:
ALTER DATABASE UPGRADE JCONNECT ON
The problems encountered were the same as those in the web site, but no solution was found [link the same ERROR][2] (Http://lists.jboss.org/pipermail/hibernate-issues/2009-August/016491.html)
Show us the whole error stack.
(Note: The comment above was originally posted as an answer, but it contains no material that attempts to answer the question.)
PLEASE STOP WASTING OUR TIME with links to DIFFERENT PROBLEMS.
That link DOES NOT CONTAIN a JZ0SJ error.