I'm assuming the URL that you want to set is :
jdbc:mysql:://localhost/railstest_development
Following syntax will help to create the connection pool.
asadmin create-jdbc-connection-pool --datasourceclassname
com.mysql.jdbc.jdbc2.optional.MyqlConnectionPoolDataSource --restype
javax.sql.DataSource --property "User=root:Password=root:URL=jdbc\:mysql
\:\://localhost/railstest_development" jdbc/railstestpool
Thanks,
-Jagadish
On Mon, 2007-09-10 at 21:28 -0700, Arun Gupta wrote:
> I'm tyring to create a JDBC connection pool through command line and
> getting the following error:
>
> -- cut here --
> C:\glassfish\bin>asadmin create-jdbc-connection-pool
> --datasourceclassname
> com.mysql.jdbc.jdbc2.optional.MyqlConnectionPoolDataSource --restype
> javax.sql.DataSource --property
> User=root:Password=root:URL=jdbc\\:mysql:\\://localhost/railstest_development
> jdbc/railstestpool
> Usage: create-jdbc-connection-pool --datasourceclassname classname
> [--terse=fals
> e] [--echo=false] [--interactive=true] [--host localhost] [--port
> 4848|4849] [--
> secure | -s] [--user admin_user] [--passwordfile file_name] [--restype
> res_type]
> [--steadypoolsize 8] [--maxpoolsize 32] [--maxwait 60000]
> [--poolresize 2] [--i
> dletimeout 300] [--isolationlevel isolation_level]
> [--isisolationguaranteed] [--
> isconnectvalidatereq=false] [--validationmethod auto-commit]
> [--validationtable
> tablename] [--failconnection=false] [--allownoncomponentcallers=false]
> [--nontra
> nsactionalconnections=false] [--description text] [--property
> (name=value)[:name
> =value]*] jdbc_connection_pool_id
> CLI131 Invalid property syntax.
> -- cut here --
>
> The error message is probably valid but of no help. What's missing ?
>
> -Arun