users@glassfish.java.net

Re: Creating connection pools from command line

From: <glassfish_at_javadesktop.org>
Date: Mon, 04 May 2009 10:46:34 PDT

Turns out that ':' was a really bad choice for the property delimiter. So, you need to escape it. However it appears to me that shell interferes in your case. The following works for me:

[code]
/asadmin create-jdbc-connection-pool --port 5048 --user admin --datasourceclassname
oracle.jdbc.pool.OracleConnectionPoolDataSource --restype
javax.sql.ConnectionPoolDataSource
--property "User=hr:Password=hrPassword:URL=jdbc\:oracle\:thin\:@localhost\:1521\:xe" TestPool
Command create-jdbc-connection-pool executed successfully.
[/code]

and creates the following in domain.xml:

[code]
 47 <property name="Password" value="hrPassword"/>
 48 <property name="URL" value="jdbc:oracle:thin:@localhost:1521:xe"/>
 49 <property name="User" value="hr"/>
[/code]

in essence,
- no double \\
- double quotes around value of --property
- escape the ':' that you want to be treated verbatim.

Hope this helps and sorry for the trouble,

-Kedar
[Message sent by forum member 'km' (km)]

http://forums.java.net/jive/thread.jspa?messageID=344886