dev@glassfish.java.net

Re: Invalid property syntax

From: Jagadish Prasath Ramu <Jagadish.Ramu_at_Sun.COM>
Date: Tue, 11 Sep 2007 12:14:51 +0530

AS_ADMIN_PASSWORD=ADMINPASSWORD

On Mon, 2007-09-10 at 23:36 -0700, Arun Gupta wrote:
> A follow up question is that ping-connection-pool command is failing.
>
> C:\testbed\glassfish\rc4\glassfish\bin>asadmin ping-connection-pool
> --user arun
> --interactive=true jdbc/railstestpool
> Invalid user or password
> CLI137 Command ping-connection-pool failed.
>
> The doc says --passwordfile should refer to a file with all keys
> starting from AS_ADMIN_. What suffix do I use for specifying this password ?
>
> -Arun
>
> Jagadish Prasath Ramu wrote:
> > 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
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: dev-unsubscribe_at_glassfish.dev.java.net
> > For additional commands, e-mail: dev-help_at_glassfish.dev.java.net
> >
>