users@glassfish.java.net

Creating connection pools from command line

From: <glassfish_at_javadesktop.org>
Date: Mon, 04 May 2009 10:15:40 PDT

The syntax is like this:

create-jdbc-connection-pool
     [--terse={true|false}][ --echo={true|false} ]
     [ --interactive={true|false} ] [ --host host]
     [--port port] [--secure| -s ] [ --user admin_user]
     [--passwordfile filename] [--help]
     [ --target target]
     [--datasourceclassname classname] [--restype res_type]
     [--steadypoolsize poolsize] [--maxpoolsize poolsize]
     [--maxwait time] [--poolresize limit]
     [--idletimeout time] [--isolationlevel isolation_level]
     [--isolationguaranteed=true] [--isconnectvalidatereq=false]
     [--validationmethod auto-commit] [--validationtable tablename]
     [--failconnection=false] [--allownoncomponentcallers=false]
     [--nontransactionalconnections=false]
     [--description text] [--property (name=value)
     [:name=value]*] connectionpoolid

I use `\' to escape the colons in a value of the --property, but the error is "CLI131 Invalid property syntax".

asadmin create-jdbc-connection-pool --user admin --passwordfile ~/Desktop/password.file --datasourceclassname oracle.jdbc.pool.OracleConnectionPoolDataSource --restype javax.sql.ConnectionPoolDataSource --property User=hr:Password=hrPassword:URL=jdbc\:oracle\:thin\:\@localhost\:1521\:xe TestPool

Thank you.
[Message sent by forum member 'dxxvi' (dxxvi)]

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