Re: J2EEStore schema problem

[Oliver Zeigermann]

I seems you combined two incompatible store versions. SQL code seems to 
have lower case table names, while schema is upper case. If you need 
something working *now* do not mix stuff, but use what Ashok has sent. 
If you can wait some time, wait for the store in the proposals section 
of the CVS. Though, it does not work, yet.

Oliver

Patrick van Kann wrote:

Hello,

I just configured the J2EEStore according to various  instructions 
posted  to this list. The version of J2EEStore I am using is "Revision: 
1.6" according to the header in the J2EEStore.java... it's in the last 
nightly build I could find that would actually compile.

Everything went fine (i.e. tyrex datasource config, server.xml and 
web.xml), except at Domain initiation I get this SQL Exception.

19 Nov 2003 12:54:24 - slidestore.j2ee.J2EEDescriptorsStore - ERROR - 
java.sql.SQLException: [FC-PK-01]Invalid object name 'objects'.

I'm using a schema called SLIDE_DB_SCHEMA_NFK.SQL. This was sent by 
Ashok to this list some time ago - I'm guessing that the schema is out 
of date because it accompanied a version of the J2EE stores labelled 
"Revision: 1.5".

Can someone point me to the correct schema... or alternatively to the 
J2EE store I should be using!

BTW: My database is SQL Server 2000 and the driver is the InetSoft 
Opta2000 driver. I'm running Slide as a webapp in Tomcat 4.1.18.

Cheers,

Patrick



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
.





---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]