Try this
<class-descriptor class="com.ojb.SomeClass"
table="PROJECT_FOO.SOME_TABLE">
...
"Brown, Melonie S. - Contractor" <[EMAIL PROTECTED]>
10.07.2003 19:03
Please respond to "OJB Users List"
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc:
Subject: Oracle Connection & Schema Question
A directive was handed down by our dba's as follows. . .
"There will be a schema called PROJECT_FOO which contains data, views,
procedures, etc.
There will be a userid called FOOUSER which will be used by the
application
to do what needs to be doing on the database (read, write).
In developing code all calls to the database should include the prefix of
the schema i.e. PROJECT_FOO.myusertable, PROJECT_FOO.mytable, etc."
Our repository.xml looks like this:
<jdbc-connection-descriptor
platform="Oracle"
jdbc-level="2.0"
driver="com.p6spy.engine.spy.P6SpyDriver"
protocol="jdbc"
subprotocol="Oracle"
dbalias="thin:@999.999.99.999:8888:SERVER"
username="FOOUSER"
password="foopassword"
jcd-alias="default"
default-connection="true"
batch-mode="false"
useAutoCommit="1"
ignoreAutoCommitExceptions="false"
>
<sequence-manager
className="org.apache.ojb.broker.util.sequence.SequenceManagerNextValImpl">
</sequence-manager>
</jdbc-connection-descriptor>
With OJB, where would the schema be specified?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
