Hi,
we use the following jdbc-connection-descriptor in repository_database.xml for Oracle
8i, we use the "Oracle thin driver" (not the oci driver, as the thin driver is type 4
an platform independent, you essecially only need to have 2 files in your classpath:
classes12.jar (or .zip) and nls_charset12.jar (or .zip)):
<jdbc-connection-descriptor
jcd-alias="default"
default-connection="true"
platform="Oracle"
jdbc-level="2.0"
driver="oracle.jdbc.driver.OracleDriver"
protocol="jdbc"
subprotocol="oracle"
dbalias="thin:@<servername>:<port>:<instance_name>"
username="<user>"
password="<password>"
batch-mode="false"
eager-release="false"
useAutoCommit="2"
ignoreAutoCommitExceptions="false"
>
<connection-pool
maxActive="10"
maxIdle="5"
maxWait="-1"
minEvictableIdleTimeMillis="6000"
numTestsPerEvictionRun="5"
testOnBorrow="false"
testOnReturn="false"
testWhileIdle="false"
timeBetweenEvictionRunsMillis="60000"
whenExhaustedAction="2"
validationQuery="" />
<sequence-manager
className="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl">
<attribute attribute-name="grabSize" attribute-value="10"/>
</sequence-manager>
</jdbc-connection-descriptor>
where: <servername> = name or ip-adress of the db server machine
<port> = port of the listener (usually 1521)
<instance_name> = name of the oracle instance (usually the name of your
database)
<user>, <password> shoud be clear.
Hope that helps.
Regards,
Max
> -----Urspr�ngliche Nachricht-----
> Von: Chang Sau Sheong [mailto:[EMAIL PROTECTED]
> Gesendet: Mittwoch, 26. M�rz 2003 03:01
> An: Geigl Maximilian, R235; [EMAIL PROTECTED]
> Betreff: dbalias for Oracle question
>
>
> Hi,
>
>
>
> I searched through the archives for this question on dbalias
> for Oracle and
> I found the thread that mentioned it but unfortunately the
> archives seems to
> be down. Can someone please help me here? I'm trying to
> connect to an Oracle
> database but there is no documentation that I can find that
> tells me what
> the dbalias looks like in the repository.xml! Would
> appreciate any help on
> this.
>
>
>
> Thanks!
>
>
>
> Chang Sau Sheong
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
