users@glassfish.java.net

Re: Creating connection pools from command line

From: Jon Faldmo <jfaldmo_at_gmail.com>
Date: Mon, 4 May 2009 11:21:38 -0600

Try it with double backslashes, and I haven't used one in front of the "@"
before...

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


On Mon, May 4, 2009 at 11:15 AM, <glassfish_at_javadesktop.org> wrote:

> 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
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
>