The Hibernate connection SyBase ASA can create tables and cannot insert data

[ximen]

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)

[Breck_Carter]

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.

https://support.sap.com/software.html
Support Packages & Patches - Access downloads
Archive by Alphabetical Index (A-Z)
S - SYBASE SQL ANYWHERE - 12.0
WINDOWS ON X64 64-BIT
Latest download: SQL Anywhere 12.0.1.4436 EBF

[Breck_Carter]

Is that the whole error stack?

Are there any "Caused by" entries in the stack?

[ximen]

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

[ximen]

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)

[Breck_Carter]

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.)

[Breck_Carter]

Http://lists.jboss.org/pipermail/hibernate-issues/2009-August/016491.html

PLEASE STOP WASTING OUR TIME with links to DIFFERENT PROBLEMS.

That link DOES NOT CONTAIN a JZ0SJ error.