Technical Support Forum Access ChemAxon scientists and developers here. For confidential or other support please email. The time now is Tue Dec 02, 2008 12:38 am
			Register (required to post and download)  Username:    Password:   Remember login
			FAQ   Search   Digests

Error creating IJC Schema

To watch this topic for replies  Register (enables digests) or give email address:

Home -> Forums -> Support -> Storage & search: Instant JChem -> Error creating IJC Schema

Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First      View previous topic :: View next topic
Author	Message
prous Joined: 29 Apr 2004 Posts: 94 Back to top	Post subject: Error creating IJC Schema Posted: Thu Mar 13, 2008 12:17 pm  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: 1830 Time(s)  Description:
tdudgeon Joined: 05 Oct 2004 Posts: 617 IJC personnel Back to top	Post subject: Posted: Thu Mar 13, 2008 12:55 pm  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
tdudgeon Joined: 05 Oct 2004 Posts: 617 IJC personnel Back to top	Post subject: Posted: Tue Apr 29, 2008 5:17 pm  This problem has now been resolved in IJC 2.3.
Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First

	Home -> Forums -> Storage & search: Instant JChem -> Error creating IJC Schema	All times are GMT + 1 Hour
Page 1 of 1

To watch this topic for replies   Register (enables digests) or give email address

Jump to: Select a forum Support----------------Drawing & visualization: Marvin/Sketch /View /SpaceStorage & search: JChem Base /CartridgeStorage & search: Instant JChemStorage & search: Markush search & enumerationLibrary profiling: Structure based prediction & Chemical TermsLibrary profiling: Virtual screening, clustering & molecular descriptorsStructure manipulation: Canonicalization / standardizationStructure manipulation: Reactor & FragmenterIntegration: Pipeline PilotIntegration: .NETOther: Naming topics & chemicalize.orgOther: License issues Contributed Software----------------Contributions to the community Implementations----------------Public implementationsOffline & not public implementations Academic Package----------------Application FormQ & ANewsListing User Group Meeting----------------Boston 2008Visegrad 20082008 User Group MeetingFuture eventsBudapest 2007Budapest 2006Budapest 2005 Site feedback----------------Problems and missing pages/features with the new siteForum problems  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