Technical Support Forum Index
Technical Support Forum
Access ChemAxon scientists and developers here. For registration and login issues contact website support.

Support Ticket System is replacing forum

This forum was converted into a searchable archive. You cannot add posts here any more. For support please use our new Ticket System.

Create your first ticket
Error creating IJC Schema
To watch this topic for replies  Register (enables digests) or give email address:
This topic is locked: you cannot edit posts or make replies.
Display posts from previous:   
    View previous topic :: View next topic    
Author Message
Gerard

Joined: 29 Apr 2004
Posts: 94

View user's profile

Back to top
Link to postPosted: Thu Mar 13, 2008 12:17 pmPost subject: Error creating IJC Schema Reply with quote

Oracle 10.2.0.3

Connected as sys user. Cannot create schema due to the error in the attachment.

Thanks.



 Filename: error_creating_ijc_schema.bmp    Filesize: 1.26 MB    Viewed: 7139 Time(s)
 Description:  
error_creating_ijc_schema.bmp
Tim
ChemAxon personnel
Joined: 05 Oct 2004
Posts: 1703

View user's profile

Back to top
Link to postPosted: Thu Mar 13, 2008 12:55 pmPost subject: Reply with quote

This is strange. It is caused by Oracle returning a JDBC data type of -101, which is not a valid value.Oracle seems to be defining extra values that are not part of the JDBC definition.

A google search finds this:
http://jira.codehaus.org/browse/JRUBY-970
suggesting that Oracle might be using this value for a column type of 'TIMESTAMP(6) WITH TIME ZONE'

I guess that what has happened is that you have tried to connect IJC to an existing oracle database, and one of the tables contains one of these column types. If you can confirm this then we can probably provide a way of working around the problem e.g. treating -101 as 93, which is the value for TIMESTAMP.


Tim
Tim
ChemAxon personnel
Joined: 05 Oct 2004
Posts: 1703

View user's profile

Back to top
Link to postPosted: Tue Apr 29, 2008 5:17 pmPost subject: Reply with quote

This problem has now been resolved in IJC 2.3.
This topic is locked: you cannot edit posts or make replies.
Page 1 of 1


To watch this topic for replies   Register (enables digests) or give email address  
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum