Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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)

alt text

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)

asked 24 Jul '17, 02:48

mfkpie8's gravatar image

mfkpie8
273667175
accept rate: 12%

edited 25 Jul '17, 07:24

Comment Text Removed

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
(24 Jul '17, 04:24) Breck Carter

Is that the whole error stack?

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

(24 Jul '17, 08:01) Breck Carter

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

(24 Jul '17, 08:03) mfkpie8
Replies hidden

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)

(25 Jul '17, 07:25) mfkpie8
Replies hidden

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

(25 Jul '17, 13:41) Breck Carter
Comment Text Removed
1

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.

(25 Jul '17, 13:45) Breck Carter
More comments hidden
showing 4 of 6 show all flat view
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×6

question asked: 24 Jul '17, 02:48

question was seen: 1,329 times

last updated: 25 Jul '17, 13:51