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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
