invalid connection string
451080Mar 22 2006 — edited Mar 23 2006Hi
I changed the database connection in sessions.xml to use datasource which I defined in application server(OC4J). Previously I was using connection url. I was told by Oracle that using the datasource defined in application sever is efficient as connections are handled more efficiently. However I am getting the following error
Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 (10.1.3.0.0) (Build 060118)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Io exception: Invalid connection string format, a valid format is: "//host:port/service_name"
This is how I defined in sessions.xml
<session-type>
<server-session/>
</session-type>
<login>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<datasource>jdbc/TestDS</datasource>
<platform-class>oracle.toplink.platform.database.oracle.Oracle10Platform</platform-class>
<user-name>test</user-name>
<encryption-class-name>oracle.toplink.internal.security.JCEEncryptor</encryption-class-name>
<encrypted-password>F44034A2DD8158AE210B5BE5CCF7B326</encrypted-password>
</login>
</session>
Thanks