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]
