Home.... | log in.... | Pub my question! | Sign-up....

Java-index >> Application & Integration Servers >> Application Servers

glassfish application server 9 with mysql

Hello!

I'm using Glassfish and i'm attemting to configurate with mysql bd.

I did an application with java studio creator 2 update 1, and it connect with mysql perfectly, but when I put the application in to the server, I see the page but not connect to mysql and I don't see any error.

Can someone explain me how configure this connection?

I have problems with the classpath suffix, what connector use (version) and what resource type use:

- javax.sql.connectionPoolDataSource or javax.sql.datasource or javax.sql.XAdatasource

And what datasource classname?

I think that "com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource" but... i don't know. I'm very confusing.

Can someone help me, please?

Sorry for my old post.

Thanks

[804 byte] By [joeljoel] at [2007-11-26 9:03:19]

«« minor strange things on CAPS 5.1
»» java.sql.SQLException: Internal Error in RowSetReader: no connection or com

# 1

1) You can add the path of mysql driver file to app server's domain.xml. Append this path to classpath-suffix.

2) Alternatively, put the driver jar file in domains/domain-name/lib/ext

Restart app. server for both the cases.

Selection of datasource: depends on your requirement. (you can check JDBC Spec / J2ee Connector Architecture spec for more details)

configuring datasource :

App Server Developer guide

http://docs.sun.com/app/docs/doc/819-3659/6n5s6m5bi?a=view

MySQL sample configuration:

App Server Administration guide :

http://docs.sun.com/app/docs/doc/819-3658/6n5s5nklk?a=view

javax.sql.DataSource - MySQL Implementation - com.mysql.jdbc.jdbc2.optional.MysqlDataSource

javax.sql.ConnectionPoolDataSource -

com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource

javax.sql.XADataSource

com.mysql.jdbc.jdbc2.optional.MysqlXADataSource

Thanks,

-Jagadish

JagadishPrasath at 2007-7-6 23:12:04 >

top of Java-index,Application & Integration Servers,Application Servers...

# 2

Thanks for your help, but it no works, I configure all that you said me, but it no works, the application runs in the server, but no appear mysql information, ping succeed but i think that the server not connect with mysql or i don't know... Can you help me more, please?

joelnogjoel at 2007-7-6 23:12:04 >

# 3

Can you post your jdbc conn pool configuration from domain.xml ?Can you post the exceptions found ? (from server.log)How does your application lookup and use the DataSource? (code snippets will help to understand it better)Thanks,-Jagadish

JagadishPrasath at 2007-7-6 23:12:04 >

# 4

THIS IS MY DOMAIN.XML

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE domain PUBLIC "-//Sun Microsystems Inc.//DTD Application Server 8.0 Domain//EN" "http://www.sun.com/software/appserver/dtds/sun-domain_1_2.dtd">

<!--

Use is subject to license terms.

-->

<j2ee-application availability-enabled="false" directory-deployed="false" enabled="true" java-web-start-enabled="true" location="${com.sun.aas.instanceRoot}/applications/j2ee-apps/MEjbApp" name="MEjbApp" object-type="system-all"/>

<web-module availability-enabled="false" context-root="/web1" directory-deployed="true" enabled="true" location="${com.sun.aas.installRoot}/lib/install/applications/adminapp/adminapp _war" name="adminapp" object-type="system-admin">

</web-module>

<web-module availability-enabled="false" context-root="/asadmin" directory-deployed="true" enabled="true" location="${com.sun.aas.installRoot}/lib/install/applications/admingui/adminGUI _war" name="admingui" object-type="system-admin">

</web-module>

<web-module availability-enabled="false" context-root="/hello" directory-deployed="false" enabled="true" location="${com.sun.aas.instanceRoot}/applications/j2ee-modules/hello" name="hello" object-type="user"/>

<web-module availability-enabled="false" context-root="holamundo" directory-deployed="false" enabled="true" location="${com.sun.aas.instanceRoot}/applications/j2ee-modules/holamundo" name="holamundo" object-type="user"/>

<web-module availability-enabled="false" context-root="taulaapp" directory-deployed="false" enabled="true" location="${com.sun.aas.instanceRoot}/applications/j2ee-modules/taulaapp" name="taulaapp" object-type="user"/>

</applications>

<jdbc-resource enabled="true" jndi-name="jdbc/__TimerPool" object-type="system-admin" pool-name="__TimerPool"/>

<jdbc-resource enabled="true" jndi-name="jdbc/__CallFlowPool" object-type="system-all" pool-name="__CallFlowPool"/>

<jdbc-resource enabled="true" jndi-name="jdbc/__default" object-type="user" pool-name="DerbyPool"/>

<jdbc-resource enabled="true" jndi-name="jdbc/web" object-type="user" pool-name="MySQL">

<description>Conexion a la bd</description>

</jdbc-resource>

<jdbc-connection-pool allow-non-component-callers="false" connection-validation-method="auto-commit" datasource-classname="org.apache.derby.jdbc.EmbeddedXADataSource" fail-all-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="false" is-isolation-level-guaranteed="true" max-pool-size="32" max-wait-time-in-millis="60000" name="__CallFlowPool" non-transactional-connections="false" pool-resize-quantity="2" res-type="javax.sql.XADataSource" steady-pool-size="8">

</jdbc-connection-pool>

<jdbc-connection-pool allow-non-component-callers="false" connection-validation-method="auto-commit" datasource-classname="org.apache.derby.jdbc.EmbeddedXADataSource" fail-all-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="false" is-isolation-level-guaranteed="true" max-pool-size="32" max-wait-time-in-millis="60000" name="__TimerPool" non-transactional-connections="false" pool-resize-quantity="2" res-type="javax.sql.XADataSource" steady-pool-size="8">

</jdbc-connection-pool>

<jdbc-connection-pool allow-non-component-callers="false" connection-validation-method="auto-commit" datasource-classname="org.apache.derby.jdbc.ClientDataSource" fail-all-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="false" is-isolation-level-guaranteed="false" max-pool-size="32" max-wait-time-in-millis="60000" name="DerbyPool" non-transactional-connections="false" pool-resize-quantity="2" res-type="javax.sql.DataSource" steady-pool-size="8">

</jdbc-connection-pool>

<jdbc-connection-pool allow-non-component-callers="false" connection-validation-method="auto-commit" datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSour ce" fail-all-connections="true" idle-timeout-in-seconds="300" is-connection-validation-required="false" is-isolation-level-guaranteed="false" max-pool-size="32" max-wait-time-in-millis="60000" name="MySQL" non-transactional-connections="false" pool-resize-quantity="2" res-type="javax.sql.ConnectionPoolDataSource" steady-pool-size="8">

</jdbc-connection-pool>

</resources>

<http-service>

<access-log format="%client.name% %auth-user-name% %datetime% %request% %status% %response.length%" rotation-enabled="true" rotation-interval-in-minutes="15" rotation-policy="time" rotation-suffix="yyyy-MM-dd"/>

<http-listener acceptor-threads="1" address="0.0.0.0" blocking-enabled="false" default-virtual-server="server" enabled="true" family="inet" id="http-listener-1" port="8080" security-enabled="false" server-name="" xpowered-by="true">

</http-listener>

<http-listener acceptor-threads="1" address="0.0.0.0" blocking-enabled="false" default-virtual-server="server" enabled="true" family="inet" id="http-listener-2" port="8181" security-enabled="true" server-name="" xpowered-by="true">

</http-listener>

<http-listener acceptor-threads="1" address="0.0.0.0" blocking-enabled="false" default-virtual-server="__asadmin" enabled="true" family="inet" id="admin-listener" port="4848" security-enabled="false" server-name="" xpowered-by="true">

</http-listener>

<virtual-server hosts="${com.sun.aas.hostName}" http-listeners="http-listener-1,http-listener-2" id="server" log-file="${com.sun.aas.instanceRoot}/logs/server.log" state="on">

</virtual-server>

<virtual-server default-web-module="admingui" hosts="${com.sun.aas.hostName}" http-listeners="admin-listener" id="__asadmin" log-file="${com.sun.aas.instanceRoot}/logs/server.log" state="on">

</virtual-server>

<request-processing header-buffer-length-in-bytes="4096" initial-thread-count="2" request-timeout-in-seconds="30" thread-count="5" thread-increment="1"/>

<keep-alive max-connections="250" thread-count="1" timeout-in-seconds="30"/>

<connection-pool max-pending-count="4096" queue-size-in-bytes="4096" receive-buffer-size-in-bytes="4096" send-buffer-size-in-bytes="8192"/>

<http-protocol default-response-type="text/plain; charset=iso-8859-1" dns-lookup-enabled="false" forced-response-type="text/plain; charset=iso-8859-1" ssl-enabled="true" version="HTTP/1.1"/>

<http-file-cache file-caching-enabled="true" file-transmission-enabled="false" globally-enabled="true" hash-init-size="0" max-age-in-seconds="30" max-files-count="1024" medium-file-size-limit-in-bytes="537600" medium-file-space-in-bytes="10485760" small-file-size-limit-in-bytes="2048" small-file-space-in-bytes="1048576"/>

</http-service>

<iiop-service client-authentication-required="false">

<iiop-listener address="0.0.0.0" enabled="true" id="orb-listener-1" port="3700" security-enabled="false"/>

<iiop-listener address="0.0.0.0" enabled="true" id="SSL" port="3820" security-enabled="true">

</iiop-listener>

<iiop-listener address="0.0.0.0" enabled="true" id="SSL_MUTUALAUTH" port="3920" security-enabled="true">

</iiop-listener>

</iiop-service>

<admin-service system-jmx-connector-name="system" type="das-and-server">

<jmx-connector accept-all="false" address="0.0.0.0" auth-realm-name="admin-realm" enabled="true" name="system" port="8686" protocol="rmi_jrmp" security-enabled="false"/>

<das-config admin-session-timeout-in-minutes="60" autodeploy-dir="${com.sun.aas.instanceRoot}/autodeploy" autodeploy-enabled="true" autodeploy-jsp-precompilation-enabled="false" autodeploy-polling-interval-in-seconds="2" autodeploy-verifier-enabled="false" deploy-xml-validation="full" dynamic-reload-enabled="true" dynamic-reload-poll-interval-in-seconds="2"/>

</admin-service>

<web-container/>

<ejb-container cache-idle-timeout-in-seconds="600" cache-resize-quantity="32" commit-option="B" max-cache-size="512" max-pool-size="32" pool-idle-timeout-in-seconds="600" pool-resize-quantity="8" removal-timeout-in-seconds="5400" session-store="${com.sun.aas.instanceRoot}/session-store" steady-pool-size="0" victim-selection-policy="nru">

<ejb-timer-service max-redeliveries="1" minimum-delivery-interval-in-millis="7000" redelivery-interval-internal-in-millis="5000"/>

</ejb-container>

<mdb-container idle-timeout-in-seconds="600" max-pool-size="32" pool-resize-quantity="8" steady-pool-size="0"/>

<jms-service addresslist-behavior="random" addresslist-iterations="3" default-jms-host="default_JMS_host" init-timeout-in-seconds="60" reconnect-attempts="3" reconnect-enabled="true" reconnect-interval-in-seconds="5" type="EMBEDDED">

<jms-host admin-password="admin" admin-user-name="admin" host="joel.domnog.naturaloptics.com" name="default_JMS_host" port="7676"/>

</jms-service>

<log-service alarms="false" file="${com.sun.aas.instanceRoot}/logs/server.log" log-rotation-limit-in-bytes="2000000" log-rotation-timelimit-in-minutes="0" log-to-console="false" retain-error-statistics-for-hours="5" use-system-logging="false">

<module-log-levels admin="INFO" classloader="INFO" cmp="INFO" cmp-container="INFO" configuration="INFO" connector="INFO" corba="INFO" deployment="INFO" ejb-container="INFO" group-management-service="INFO" javamail="INFO" jaxr="INFO" jaxrpc="INFO" jdo="INFO" jms="INFO" jta="INFO" jts="INFO" management-event="INFO" mdb-container="INFO" naming="INFO" node-agent="INFO" resource-adapter="INFO" root="INFO" saaj="INFO" security="INFO" self-management="INFO" server="INFO" synchronization="INFO" util="INFO" verifier="INFO" web-container="INFO"/>

</log-service>

<security-service activate-default-principal-to-role-mapping="false" anonymous-role="ANYONE" audit-enabled="false" audit-modules="default" default-realm="file" jacc="default">

<auth-realm classname="com.sun.enterprise.security.auth.realm.file.FileRealm" name="admin-realm">

</auth-realm>

<auth-realm classname="com.sun.enterprise.security.auth.realm.file.FileRealm" name="file">

</auth-realm>

<auth-realm classname="com.sun.enterprise.security.auth.realm.certificate.CertificateRealm" name="certificate">

</auth-realm>

<jacc-provider name="default" policy-configuration-factory-provider="com.sun.enterprise.security.provider.Pol icyConfigurationFactoryImpl" policy-provider="com.sun.enterprise.security.provider.PolicyWrapper">

</jacc-provider>

<audit-module classname="com.sun.enterprise.security.Audit" name="default">

</audit-module>

<message-security-config auth-layer="SOAP">

<provider-config class-name="com.sun.xml.wss.provider.ClientSecurityAuthModule" provider-id="XWS_ClientProvider" provider-type="client">

<request-policy auth-source="content"/>

<response-policy auth-source="content"/>

</provider-config>

<provider-config class-name="com.sun.xml.wss.provider.ClientSecurityAuthModule" provider-id="ClientProvider" provider-type="client">

<request-policy auth-source="content"/>

<response-policy auth-source="content"/>

</provider-config>

<provider-config class-name="com.sun.xml.wss.provider.ServerSecurityAuthModule" provider-id="XWS_ServerProvider" provider-type="server">

<request-policy auth-source="content"/>

<response-policy auth-source="content"/>

</provider-config>

<provider-config class-name="com.sun.xml.wss.provider.ServerSecurityAuthModule" provider-id="ServerProvider" provider-type="server">

<request-policy auth-source="content"/>

<response-policy auth-source="content"/>

</provider-config>

</message-security-config>

</security-service>

<transaction-service automatic-recovery="false" heuristic-decision="rollback" keypoint-interval="2048" retry-timeout-in-seconds="600" timeout-in-seconds="0" tx-log-dir="${com.sun.aas.instanceRoot}/logs"/>

<monitoring-service>

<module-monitoring-levels connector-connection-pool="OFF" connector-service="OFF" ejb-container="OFF" http-service="OFF" jdbc-connection-pool="OFF" jms-service="OFF" jvm="OFF" orb="OFF" thread-pool="OFF" transaction-service="OFF" web-container="OFF"/>

</monitoring-service>

<diagnostic-service capture-app-dd="true" capture-hadb-info="true" capture-install-log="true" capture-system-info="true" compute-checksum="true" max-log-entries="500" min-log-level="INFO" verify-config="true"/>

<java-config debug-enabled="false" debug-options="-Xdebug -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=9009" env-classpath-ignored="true" java-home="${com.sun.aas.javaRoot}" javac-options="-g" rmic-options="-iiop -poa -alwaysgenerate -keepgenerated -g" system-classpath="${com.sun.aas.installRoot}/lib/appserv-launch.jar">

<jvm-options>-client</jvm-options>

<jvm-options>-Djava.endorsed.dirs=${com.sun.aas.installRoot}/lib/endorsed </jvm-options>

<jvm-options>-Djava.security.policy=${com.sun.aas.instanceRoot}/config/se rver.policy</jvm-options>

<jvm-options>-Djava.security.auth.login.config=${com.sun.aas.instanceRoot }/config/login.conf</jvm-options>

<jvm-options>-Dsun.rmi.dgc.server.gcInterval=3600000</jvm-options>

<jvm-options>-Dsun.rmi.dgc.client.gcInterval=3600000</jvm-options>

<jvm-options>-Xmx512m</jvm-options>

<jvm-options>-Djavax.net.ssl.keyStore=${com.sun.aas.instanceRoot}/config/ keystore.jks</jvm-options>

<jvm-options>-Djavax.net.ssl.trustStore=${com.sun.aas.instanceRoot}/confi g/cacerts.jks</jvm-options>

<jvm-options>-Djava.ext.dirs=${com.sun.aas.javaRoot}/jre/lib/ext${path.se parator}${com.sun.aas.instanceRoot}/lib/ext${path.separator}${com.sun.aas.derbyR oot}/lib</jvm-options>

<jvm-options>-Djdbc.drivers=org.apache.derby.jdbc.ClientDriver</jvm-op tions>

<jvm-options>-Djavax.management.builder.initial=com.sun.enterprise.admin. server.core.jmx.AppServerMBeanServerBuilder</jvm-options>

<jvm-options>-Dcom.sun.enterprise.config.config_environment_factory_class =com.sun.enterprise.config.serverbeans.AppserverConfigEnvironmentFactory</jvm -options>

<jvm-options>-Dcom.sun.enterprise.taglibs=appserv-jstl.jar,jsf-impl.jar&l t;/jvm-options>

<jvm-options>-Dcom.sun.enterprise.taglisteners=jsf-impl.jar</jvm-optio ns>

<jvm-options>-XX:NewRatio=2</jvm-options>

<jvm-options>-XX:MaxPermSize=256m</jvm-options>

</java-config>

<thread-pools>

<thread-pool idle-thread-timeout-in-seconds="120" max-thread-pool-size="200" min-thread-pool-size="0" num-work-queues="1" thread-pool-id="thread-pool-1"/>

</thread-pools>

<management-rules enabled="true">

</management-rules>

</config>

</configs>

<application-ref disable-timeout-in-minutes="30" enabled="true" lb-enabled="false" ref="adminapp" virtual-servers="__asadmin"/>

<application-ref disable-timeout-in-minutes="30" enabled="true" lb-enabled="false" ref="admingui" virtual-servers="__asadmin"/>

<application-ref disable-timeout-in-minutes="30" enabled="true" lb-enabled="false" ref="MEjbApp" virtual-servers="server"/>

<application-ref disable-timeout-in-minutes="30" enabled="true" lb-enabled="false" ref="__ejb_container_timer_app" virtual-servers="server"/>

<application-ref disable-timeout-in-minutes="30" enabled="true" lb-enabled="false" ref="__JWSappclients" virtual-servers="server"/>

<application-ref disable-timeout-in-minutes="30" enabled="true" lb-enabled="false" ref="hello" virtual-servers="server"/>

<application-ref disable-timeout-in-minutes="30" enabled="true" lb-enabled="false" ref="holamundo" virtual-servers="server"/>

<application-ref disable-timeout-in-minutes="30" enabled="true" lb-enabled="false" ref="taulaapp" virtual-servers="server"/>

<resource-ref enabled="true" ref="jdbc/__TimerPool"/>

<resource-ref enabled="true" ref="jdbc/__CallFlowPool"/>

<resource-ref enabled="true" ref="jdbc/__default"/>

<resource-ref enabled="true" ref="jdbc/web"/>

</server>

</servers>

</domain>

THIS IS MY SERVER.LOG

ElementProperty[6]#0:Description<null>

attr: Name=user attr: Value=root#1:Description<null>

attr: Name=port attr: Value=3306#2:Description<null>

attr: Name=password attr: Value=informatica#3:Description<null>

attr: Name=databaseName attr: Value=naturalview#4:Description<null>

attr: Name=serverName attr: Value=192.168.1.2#5:Description<null>

attr: Name=URL attr: Value=jdbc:mysql://192.168.1.7:3306/naturalview?relaxAutoCommit="true"|#]

ElementProperty[6]#0:Description<null>

attr: Name=user attr: Value=root#1:Description<null>

attr: Name=port attr: Value=3306#2:Description<null>

attr: Name=password attr: Value=informatica#3:Description<null>

attr: Name=databaseName attr: Value=naturalview#4:Description<null>

attr: Name=serverName attr: Value=192.168.1.2#5:Description<null>

attr: Name=URL attr: Value=jdbc:mysql://192.168.1.2:3306/naturalview?relaxAutoCommit="true"|#]

[#|2006-07-27T10:38:37.546+0200|WARNING|sun-appserver-pe9.0|javax.enterprise.re source.resourceadapter|_ThreadID=12;_ThreadName=httpWorkerThread-4848-0;_Request ID=6905e2e5-e7cd-4bbf-9211-7a674b90abda;|Connection could not be allocated because: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException

MESSAGE: java.net.ConnectException: Connection timed out: no further information

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection timed out: no further information

at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)

at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)

at com.mysql.jdbc.Connection.createNewIO(Connection.java:2555)

at com.mysql.jdbc.Connection.<init>(Connection.java:1485)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)

at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.jav a:425)

at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.jav a:140)

at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.jav a:110)

at com.sun.gjc.spi.DSManagedConnectionFactory.createManagedConnection(DSManagedCon nectionFactory.java:100)

at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.getUnpool edConnection(ConnectorConnectionPoolAdminServiceImpl.java:1200)

at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.testConne ctionPool(ConnectorConnectionPoolAdminServiceImpl.java:543)

at com.sun.enterprise.connectors.ConnectorRuntime.testConnectionPool(ConnectorRunt ime.java:502)

at com.sun.enterprise.admin.mbeans.ResourcesMBean.pingConnectionPool(ResourcesMBea n.java:2218)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at com.sun.enterprise.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:353 )

at com.sun.enterprise.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:336 )

at com.sun.enterprise.admin.config.BaseConfigMBean.invoke(BaseConfigMBean.java:448 )

at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:213 )

at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:220)

at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServer Interceptor.java:815)

at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:784)

at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at com.sun.enterprise.admin.util.proxy.ProxyClass.invoke(ProxyClass.java:77)

at $Proxy1.invoke(Unknown Source)

at com.sun.enterprise.admin.server.core.jmx.SunoneInterceptor.invoke(SunoneInterce ptor.java:297)

at com.sun.enterprise.tools.admingui.util.MBeanUtil.invoke(MBeanUtil.java:162)

at com.sun.enterprise.tools.admingui.util.MBeanUtil.invoke(MBeanUtil.java:60)

at com.sun.enterprise.tools.admingui.handlers.CommonHandlers.invokeMBean(CommonHan dlers.java:149)

at sun.reflect.GeneratedMethodAccessor106.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at com.sun.enterprise.tools.guiframework.view.DescriptorViewHelper.invokeHandler(D escriptorViewHelper.java:938)

at com.sun.enterprise.tools.guiframework.view.DescriptorViewHelper.invokeHandlers( DescriptorViewHelper.java:875)

at com.sun.enterprise.tools.guiframework.view.DescriptorViewHelper.dispatchEvent(D escriptorViewHelper.java:841)

at com.sun.enterprise.tools.guiframework.view.DescriptorViewHelper.execute(Descrip torViewHelper.java:313)

at com.sun.enterprise.tools.guiframework.view.DescriptorViewBeanBase.execute(Descr iptorViewBeanBase.java:210)

at com.iplanet.jato.view.RequestHandlingViewBase.handleRequest(RequestHandlingView Base.java:308)

at com.iplanet.jato.view.ViewBeanBase.dispatchInvocation(ViewBeanBase.java:802)

at com.iplanet.jato.view.ViewBeanBase.invokeRequestHandlerInternal(ViewBeanBase.ja va:740)

at com.iplanet.jato.view.ViewBeanBase.invokeRequestHandlerInternal(ViewBeanBase.ja va:760)

at com.iplanet.jato.view.ViewBeanBase.invokeRequestHandler(ViewBeanBase.java:571)

at com.iplanet.jato.ApplicationServletBase.dispatchRequest(ApplicationServletBase. java:957)

at com.iplanet.jato.ApplicationServletBase.processRequest(ApplicationServletBase.j ava:615)

at com.sun.enterprise.tools.guiframework.view.BaseServlet.processRequest(BaseServl et.java:204)

at com.iplanet.jato.ApplicationServletBase.doPost(ApplicationServletBase.java:473)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilte rChain.java:397)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 278)

at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)

at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextVal ve.java:240)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 179)

at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)

at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:73)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:182)

at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)

at com.sun.enterprise.web.VirtualServerPipeline.invoke(VirtualServerPipeline.java: 120)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:13 7)

at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)

at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:231)

at com.sun.enterprise.web.connector.grizzly.ProcessorTask.invokeAdapter(ProcessorT ask.java:667)

at com.sun.enterprise.web.connector.grizzly.ProcessorTask.processNonBlocked(Proces sorTask.java:574)

at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.ja va:844)

at com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask .java:287)

at com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:212)

at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:252)

at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:75)

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.|#]

ElementProperty[6]#0:Description<null>

attr: Name=user attr: Value=root#1:Description<null>

attr: Name=port attr: Value=3306#2:Description<null>

attr: Name=password attr: Value=informatica#3:Description<null>

attr: Name=databaseName attr: Value=naturalview#4:Description<null>

attr: Name=serverName attr: Value=192.168.1.7#5:Description<null>

attr: Name=URL attr: Value=jdbc:mysql://192.168.1.7:3306/naturalvie?relaxAutoCommit="true"|#]

ElementProperty[6]#0:Description<null>

attr: Name=user attr: Value=root#1:Description<null>

attr: Name=port attr: Value=3306#2:Description<null>

attr: Name=password attr: Value=informatica#3:Description<null>

attr: Name=databaseName attr: Value=naturalview#4:Description<null>

attr: Name=serverName attr: Value=192.168.1.7#5:Description<null>

attr: Name=URL attr: Value=jdbc:mysql://192.168.1.7:3306/naturalview?relaxAutoCommit="true"|#]

ElementProperty[6]#0:Description<null>

attr: Name=user attr: Value=root#1:Description<null>

attr: Name=port attr: Value=3306#2:Description<null>

attr: Name=password attr: Value=informatica#3:Description<null>

attr: Name=databaseName attr: Value=naturalview#4:Description<null>

attr: Name=serverName attr: Value=192.168.1.7#5:Description<null>

attr: Name=URL attr: Value=jdbc:mysql://192.168.1.7:3306/naturalview?relaxAutoCommit="true"|#]

ElementProperty[6]#0:Description<null>

attr: Name=user attr: Value=root#1:Description<null>

attr: Name=port attr: Value=3306#2:Description<null>

attr: Name=password attr: Value=informatica#3:Description<null>

attr: Name=databaseName attr: Value=naturalview#4:Description<null>

attr: Name=serverName attr: Value=192.168.1.7#5:Description<null>

attr: Name=URL attr: Value=jdbc:mysql://192.168.1.7:3306/naturalview?relaxAutoCommit="true"|#]

ElementProperty[6]#0:Description<null>

attr: Name=user attr: Value=root#1:Description<null>

attr: Name=port attr: Value=3306#2:Description<null>

attr: Name=password attr: Value=informatic#3:Description<null>

attr: Name=databaseName attr: Value=naturalview#4:Description<null>

attr: Name=serverName attr: Value=192.168.1.7#5:Description<null>

attr: Name=URL attr: Value=jdbc:mysql://192.168.1.7:3306/naturalview?relaxAutoCommit="true"|#]

ElementProperty[6]#0:Description<null>

attr: Name=user attr: Value=root#1:Description<null>

attr: Name=port attr: Value=3306#2:Description<null>

attr: Name=password attr: Value=informatica#3:Description<null>

attr: Name=databaseName attr: Value=naturalview#4:Description<null>

attr: Name=serverName attr: Value=192.168.1.7#5:Description<null>

attr: Name=URL attr: Value=jdbc:mysql://192.168.1.7:3306/naturalview?relaxAutoCommit="true"|#]

NAME OF CONNECTION POOL: "MYSQL"

NAME OF JDBC RESOURCE: "jdbc/web"

THANKS, THANKS!!!

joelnogjoel at 2007-7-6 23:12:04 >

# 5

>How does your application lookup and use the DataSource? (code snippets >will help to understand it better)I don't understand this question, please can tell me where i find the code snippets please, thanks

joelnogjoel at 2007-7-6 23:12:04 >

# 6

From your exception messages, I could see that mysql is rejecting connections because of access privilege.

You can grant access to connect from your machine to mysql using the following command.

syntax:

GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

From your domain.xml, for your case :

GRANT ALL PRIVILEGES ON *.* TO 'root'@'JOEL' IDENTIFIED BY 'informatic' WITH GRANT OPTION;

execute the above for your database. Hope it solves the problem.

Thanks,

-Jagadish

JagadishPrasath at 2007-7-6 23:12:04 >

# 7

no no, because the password is informatica, not informatic...I only configure connection pool and jdbc resource, is correct?

joelnogjoel at 2007-7-6 23:12:04 >

# 8

I have all the privileges about my mysql,I'm so deseperate.....

joelnogjoel at 2007-7-6 23:12:04 >

# 9

Yes, your jdbc-resource and pool configuration looks fine.

code snippet:

java code where you do "lookup" of datasource and then calling datasource.getConnection.

eg:

Context ic = new InitialContext();

DataSource o = ic.lookup("java:comp/env/jdbc/resource");

o.getConnection()

what type of application ? Web (JSP, Servlet), EJB ?

JagadishPrasath at 2007-7-6 23:12:04 >

# 10

My SQL users have complained about this before in their forum.... See the thread http://forums.java.net/jive/thread.jspa?threadID=16879&tstart=0 http://forum.java.sun.com/thread.jspa?threadID=564265&messageID=2780194Does connection from a simple java program

BinodPG at 2007-7-6 23:12:04 >

Application & Integration Servers

Application Servers

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

glassfish application server 9 with mysql

Application & Integration Servers New Topic

Application & Integration Servers Hot Topic

Application & Integration Servers

All Classified