svn commit: r492855 - in /db/ojb/branches/OJB_1_0_RELEASE/profile: oracle.profile oracle9i.profile

Author: arminw
Date: Thu Jan  4 18:21:26 2007
New Revision: 492855

URL: http://svn.apache.org/viewvc?view=rev&rev=492855
Log:
update oracle profiles

Modified:
    db/ojb/branches/OJB_1_0_RELEASE/profile/oracle.profile
    db/ojb/branches/OJB_1_0_RELEASE/profile/oracle9i.profile

Modified: db/ojb/branches/OJB_1_0_RELEASE/profile/oracle.profile
URL: http://svn.apache.org/viewvc/db/ojb/branches/OJB_1_0_RELEASE/profile/oracle.profile?view=diff&rev=492855&r1=492854&r2=492855
==============================================================================
--- db/ojb/branches/OJB_1_0_RELEASE/profile/oracle.profile (original)
+++ db/ojb/branches/OJB_1_0_RELEASE/profile/oracle.profile Thu Jan  4 18:21:26 2007
@@ -79,11 +79,26 @@
 # -------------------------------------------------------------------
 
 dbmsName = Oracle
-jdbcLevel = 1.0
+jdbcLevel = 3.0
 urlProtocol = jdbc
-urlSubprotocol = oracle
-urlDbalias = oci8:@(description=(address=(host=127.0.0.1)(protocol=tcp)(port=1521))(connect_data=(sid=orcl)))
-#urlDbalias = thin:@127.0.0.1:1521:orcl
+
+dbHost = 127.0.0.1
+dbPort = 1521
+#dbSID = ORACLE
+dbSID = XE
+
+# THIN
+urlSubprotocol = oracle:thin
+urlDbalias = @${dbHost}:${dbPort}:${dbSID}
+
+# OCI
+#urlSubprotocol = oracle:oci
+#urlDbalias = @MY_TNSNAME
+#urlDbalias = @(description=(address=(host=${dbHost})(protocol=tcp)(${dbPort}))(connect_data=(sid=${dbSID})))
+
+# validation query used to detect timed out connections
+# connection was checked when borrowed from pool
+#validationQuery=SELECT 1 FROM DUAL
 
 #
 # settings for torque 3.1.1
@@ -92,8 +107,8 @@
 torque.database.buildUrl = ${urlProtocol}:${urlSubprotocol}:${urlDbalias}
 torque.database.url = ${urlProtocol}:${urlSubprotocol}:${urlDbalias}
 torque.database.driver = oracle.jdbc.driver.OracleDriver
-torque.database.user = scott
-torque.database.password = tiger
+torque.database.user = ojb
+torque.database.password = ojb
 torque.database.host = 127.0.0.1
 
 # Tells JDBC task that javaName attribute for the tables and columns

Modified: db/ojb/branches/OJB_1_0_RELEASE/profile/oracle9i.profile
URL: http://svn.apache.org/viewvc/db/ojb/branches/OJB_1_0_RELEASE/profile/oracle9i.profile?view=diff&rev=492855&r1=492854&r2=492855
==============================================================================
Binary files - no diff available.