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, 02:48

mfkpie8's gravatar image

mfkpie8
80444953
accept rate: 9%

edited 25 Jul, 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, 04:24) Breck Carter

Is that the whole error stack?

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

(24 Jul, 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, 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, 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, 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, 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:

×4

question asked: 24 Jul, 02:48

question was seen: 163 times

last updated: 25 Jul, 13:51