When you run the oracleschema.sql script, which user are you running it
as? If you run it as the user that Slide is using to access the database
it should create the tables in that user's schema.
-James
On Tue, 2004-11-09 at 11:23 -0500, Nick Longinow wrote:
> No replies so far. So, I'm assuming not much interest or need.
>
> I am willing to do the work to update CommonRDBMSAdapter,
> StandardRDBMSAdapter and (if needed) OracleRDBMSAdapter to use a property in
> the domain.xml ('schema'), but only if it exists.
>
> (complexity will come from the 'dbo' dbs, such as Sybase, and Sqlserver)
> Any thoughts or comments about this idea ?
>
> Nick
>
>
> -----Original Message-----
> From: Nick Longinow [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 09, 2004 10:46 AM
> To: 'Slide Users Mailing List'
> Subject: Oracle store - anyone using specific schema ?
>
> The oracleschema.sql file will create the tables under the SYSTEM schema, by
> default. If I modify the script to create them under a schema, the sql in
> CommonRDBMSAdapter.java will no longer be able to find the tables.
> Has anyone attempted to use a specific schema instead of the default SYSTEM
> schema ?
> Nick
>
>
> ---------------------------------------------------------------------
> 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]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
