Jagadish,
When I click on the link I get a blank page.
I will try to set up the jdbc-connection-pool to look just like the included
example.
:-)
On Wed, Dec 17, 2008 at 9:02 PM, Jagadish Prasath Ramu <
Jagadish.Ramu_at_sun.com> wrote:
> I could see the contents of the template :
>
> http://blogs.sun.com/JagadishPrasath/resource/conpool-templates/mysql_type4_datasource.xml
>
> For reference :
>
> ----------------------------Snippet---------------------------------------------------------------------
> <jdbc-connection-pool name="mysql-pool"
> datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlDataSource"
> res-type="javax.sql.DataSource">
> <property name="user" value="DB_USER"/>
> <property name="password" value="DB_PASSWORD"/>
> <property name="url"
> value="jdbc:mysql://DB_HOSTNAME:3306/DATABASE_NAME"/>
> </jdbc-connection-pool>
> <jdbc-resource enabled="true" jndi-name="jdbc/mysql-resource"
> object-type="user" pool-name="mysql-pool"/>
>
> ----------------------------Snippet---------------------------------------------------------------------
>
> can you try setting it according to the config posted above and do a
> ping connection pool?
> If ping fails, you will see exceptions logged in server.log
> (GF_INSTALL_DIR/domains/<domain1>/logs/server.log
> Please post the exception messages.
>
> Thanks,
> -Jagadish
>
>
>
> On Wed, 2008-12-17 at 20:42 -0800, Néstor wrote:
> > Jagadish,
> >
> >
> > Yes, I do hace access from localhost to mysql. I can log in from
> > command line and also via joomla/apache I can acccess the joomla
> > database.
> >
> >
> > I went earlier to the template database page but when you click on the
> > mysql_type4_datasource.xml, the file is empty. I also downloaded
> > mysql-connector-java-5.0.8-bin.jar yesterday and put it in the
> > directory
> >
> > C:\glassfish\lib
> >
> >
> > I think this is what you asked from the domain.xml file.
> > <jdbc-connection-pool allow-non-component-callers="true"
> > associate-with-thread="false" connection-creation-retry-attempts="0"
> > connection-creation-retry-interval-in-seconds="10"
> > connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0"
> > connection-validation-method="auto-commit"
> >
> datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource"
> fail-all-connections="false" idle-timeout-in-seconds="300"
> is-connection-validation-required="false"
> is-isolation-level-guaranteed="true" lazy-connection-association="false"
> lazy-connection-enlistment="false" match-connections="false"
> max-connection-usage-count="0" max-pool-size="32"
> max-wait-time-in-millis="60000" name="mysql-pool"
> non-transactional-connections="false" pool-resize-quantity="2"
> res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1"
> steady-pool-size="8" validate-atmost-once-period-in-seconds="0"
> wrap-jdbc-objects="false">
> > <property name="datasourceName" value="mysql"/>
> > <property name="port" value="3306"/>
> > <property name="user" value="root"/>
> > <property name="password" value="loco"/>
> > <property name="databaseName" value="test"/>
> > <property name="serverName" value="localhost"/>
> > </jdbc-connection-pool>
> >
> >
> > Thanks,
> >
> >
> > Nestor :-)
> >
> >
> >
> >
> > On Wed, Dec 17, 2008 at 8:06 PM, Jagadish Prasath Ramu
> > <Jagadish.Ramu_at_sun.com> wrote:
> > Can you post your connection pool configuration ?
> > [you can find it in
> > GF_INSTALLATION_DIR/domains/<domain1>/config/domain.xml,
> > element
> > jdbc-connection-pool with your pool name]
> >
> >
> http://blogs.sun.com/JagadishPrasath/entry/jdbc_connection_pool_templates_glassfish
> >
> > has a template for MySQL (necessary properties to connect to
> > database)
> >
> > * Also, you may have to check whether MySQL is configured to
> > allow
> > access from your machine
> >
> > Thanks,
> > -Jagadish
> >
> >
> >
> > On Wed, 2008-12-17 at 19:44 -0800, Néstor wrote:
> > > I did the ping and I get an error:
> > > An error has occurred
> > > Access denied for user ''@'localhost' (using password:
> > NO)
> > >
> > >
> > >
> > > That means that somehow glassfish is using a user that has
> > no access
> > > permission.
> > > Or a user has not been configure, where do I caonfigure the
> > user in
> > > glassfisg?
> > >
> > >
> > > I know that the user that joomla is using is correct because
> > I can
> > > access mysql using joomla.
> > >
> > >
> > > Rotsen :-)
> > >
> > > On Tue, Dec 16, 2008 at 11:25 PM, Jagadish Prasath Ramu
> > > <Jagadish.Ramu_at_sun.com> wrote:
> > > Following URLs may be helpful :
> > > http://forums.mysql.com/read.php?10,155771,155771
> > > http://forum.joomla.org/viewtopic.php?f=429&t=206631
> > >
> > >
> > > This exception does not seem to come from MySQL or
> > GlassFish.
> > > Do you see any exception in GlassFish's server.log ?
> > > [GF_INSTALL_DIR/domains/<domain1>/logs]
> > >
> > > You can do "ping" on the connection pool created on
> > GlassFish
> > > to see
> > > whether your database related settings are correct.
> > > Access admin GUI, select the jdbc-connection-pool
> > and do ping.
> > >
> >
> http://blogs.sun.com/JagadishPrasath/entry/creating_jdbc_connection_pool_resource
> > >
> >
> http://blogs.sun.com/JagadishPrasath/entry/jdbc_connection_pool_templates_glassfish
> > >
> > > Thanks,
> > > -Jagadish
> > >
> > >
> > > On Tue, 2008-12-16 at 22:59 -0800, Néstor wrote:
> > > > I was sucessful at getting glassfish and
> > JavaBridge running
> > > but now I
> > > > am trying to run Joomla
> > > > with glassfish using the example
> > > > in
> > >
> >
> http://www2.sebastiendionne.ca:8282/glassfish/joomla-on-glassfish.html
> > > >
> > > >
> > > > When I try to access
> > > http://127.0.0.1:8080/JavaBridge2/joomla/ I get
> > > > the error:
> > > > Database Error: Unable to connect to the
> > database:The MySQL
> > > adapter
> > > > "mysql" is not available.
> > > >
> > > >
> > > >
> > > > I even create a JDBC COnnection and a JDBC
> > resource as
> > > describe in
> > > > this page:
> > > >
> > >
> >
> http://blog.linkedin.com/2008/08/19/jdbc-connection-pooling-for-rails-on-glassfish/
> > > >
> > > >
> > > > After searching the net, most people with this
> > problem is
> > > because they
> > > > are not able to access
> > > > mysql with php and ISS but my joomla/php/apache
> > has not
> > > problem
> > > > accessing mysql.
> > > >
> > > >
> > > > ANt ideas on how do I make glassfish talk to
> > mysql.?
> > > >
> > > >
> > > > Thanks,
> > > >
> > > >
> > > > Nestor :-)
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
> ---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> > > users-unsubscribe_at_glassfish.dev.java.net
> > > For additional commands, e-mail:
> > > users-help_at_glassfish.dev.java.net
> > >
> > >
> > >
> >
> >
> >
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> > users-unsubscribe_at_glassfish.dev.java.net
> > For additional commands, e-mail:
> > users-help_at_glassfish.dev.java.net
> >
> >
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
>