Re: Migration from Oracle 8i to Oracle 9

"Pierre Gilquin" <[email protected]> Sun, 11 Sep 2005 11:37:11 +0200
Newsgroups gmane.comp.web.webobjects.admin
Message-ID <[email protected]>
Thanks Kaj,

I did that and after installing Oracle 9i jdbc drivers everything 
(application and EoModeler with 8i and 9i) works perfectly.

Pierre

----- Original Message ----- 
From: "Kaj Hejer" <[email protected]>
To: "Pierre Gilquin" <[email protected]>
Cc: <[email protected]>
Sent: Sunday, September 11, 2005 10:38 AM
Subject: Re: Migration from Oracle 8i to Oracle 9


> Hi!
>
> Try to get an updated version of jar-file with your oracle-drivers  (often 
> called classes12.jar) just to be sure that old jdbc drivers  isnt the 
> source of the problem.
>
> -Kaj :)
>
>
> On 6. sep 2005, at 16.22, Pierre Gilquin wrote:
>
>> Hi all,
>>
>> After migration of an Oracle database from version 8i to 9, I am  not 
>> able anymore to access it either from eomodeler or from the  application.
>> I have the following error :
>>
>> Stack Trace:
>> JDBCAdaptorException: EvaluateExpression failed:
>> <OraclePlugIn$OracleExpression: "SELECT t0.UpdCode, t0.CODEBG,
>> t0.GENERICCODE, t0.GENERICGROUP, t0.GRDFRCODE, t0.GROUPCODE,  t0.HSCODE,
>> t0.IHACODE, t0.swissmediccat, t0.SWISSMEDICKEY, t0.INSCODE, 
>> t0.INSCODELIM,
>> t0.LIMPKT, t0.LOACODE, t0.NUMOFPCE, t0.PACK, t0.PHAR, t0.PRODUCTKEY,
>> t0.SALECODE, t0.STOCKFRIDGE, t0.STOCKNARC, t0.STOCKTEMP, t0.STOCKTOX,
>> t0.TOXCLASS, t0.VATCODE, t0.WWW FROM GDAC t0">:
>>    Next exception:SQL State:60000 -- error code: 600 -- msg:  ORA-00600:
>> internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [],  [], 
>> []
>>
>> at JDBCContext._jdbcErrorWithChannel(Compiled Code)
>> at JDBCChannel._evaluateExpression(JDBCChannel.java:304)
>> at JDBCChannel.evaluateExpression(JDBCChannel.java:255)
>> at JDBCChannel.selectAttributes(JDBCChannel.java:185)
>>
>>
>> Thank you in advance for any idea.
>>
>> Pierre Gilquin
>> _______________________________________________
>> WebObjects-admin mailing list
>> [email protected]
>> http://www.omnigroup.com/mailman/listinfo/webobjects-admin
>>
>
>