Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [glassfish-dev] How to use Glassfish with MySQL or any database instead of Apache Derby

Why is the data source not bound to jndi and why isn't a proper error logged when the data source has trouble deploying?  Sounds like someone needs to explain or dig into the code to improve.  I have helped a lot to run TCK tests against glass fish and problems like this should be fixed by those with the itch to fix when they happen.  

Maybe ask how one would try to find and improve the code responsible for data source deployment.

Just my two dollars of thoughts on this.  Sorry about the spell checker on my phone changing technical terms to be spelled wrong :)

Scott

On Fri, Apr 26, 2024, 10:42 AM Victor Gimenez via glassfish-dev <glassfish-dev@xxxxxxxxxxx> wrote:
Em 2024-04-26 10:29, Victor Gimenez via glassfish-dev escreveu:
> Em 2024-04-26 01:15, Hiroki Sawamura (Fujitsu) escreveu:
>> Hi,
>>
> Hi! Thanks again for the reply.
>

I did another test to verify taking all the <persistence-unit
name="MySqlUnit"> XML block on persistence.xml and I received another
message:

```
Error occurred during deployment: Exception while preparing the app :
Could not resolve a persistence unit corresponding to the
persistence-context-ref-name [dukes.greeting.GreetingRepository/em] in
the scope of the module called [challenge2]. Please verify your
application.. Please see server.log for more details.
```

>>> [challenge2] : JNDI lookup failed for the resource: Name: MySqlUnit,
>>> Lookup: jdbc/mysql, Type: javax.sql.DataSource -- Lookup failed for
>>> jdbc/mysql in
>>
>> Hm, it seems that for JPA the resource type should be
>> javax.sql.DataSource.
>> so, try changing the JDBC connection pool resource type to
>> "javax.sql.DataSource" and the data source class name to
>> "com.mysql.cj.jdbc.MysqlDataSource".
>>
>>
>
> With javax.sql.DataSource as JDBC connection pool and
> com.mysql.cj.jdbc.MysqlDataSource I am facing the same thing:
>
> ```An error has occurred Error occurred during deployment: Exception
> while deploying the app [challenge2] : JNDI lookup failed for the
> resource: Name: MySqlUnit, Lookup: jdbc/mysql, Type:
> javax.sql.DataSource -- Lookup failed for jdbc/mysql in
> SerialContext[myEnv={java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl,
> java.naming.factory.url.pkgs=com.sun.enterprise.naming}]. Please see
> server.log for more details. An error has occurred```
>
> And at the server.log almost the same:
> ```
> [2024-04-26T10:26:24.547397-03:00] [GF 7.0.13] [SEVERE] []
> [org.glassfish.admin.rest.resources.TemplateListOfResource] [tid:
> _ThreadID=90 _ThreadName=admin-listener(3)] [levelValue: 1000] [[
>   Error occurred during deployment: Exception while deploying the app
> [challenge2] : JNDI lookup failed for the resource: Name: MySqlUnit,
> Lookup: jdbc/mysql, Type: javax.sql.DataSource -- Lookup failed for
> jdbc/mysql in
> SerialContext[myEnv={java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl,
> java.naming.factory.url.pkgs=com.sun.enterprise.naming}]. Please see
> server.log for more details.]]
>
> [2024-04-26T10:26:24.548382-03:00] [GF 7.0.13] [INFO] []
> [org.glassfish.admingui] [tid: _ThreadID=92
> _ThreadName=admin-listener(5)] [levelValue: 800] [[
>   Exception Occurred :Error occurred during deployment: Exception while
> deploying the app [challenge2] : JNDI lookup failed for the resource:
> Name: MySqlUnit, Lookup: jdbc/mysql, Type: javax.sql.DataSource --
> Lookup failed for jdbc/mysql in
> SerialContext[myEnv={java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl,
> java.naming.factory.url.pkgs=com.sun.enterprise.naming}]. Please see
> server.log for more details.]]
> ```
>
> I am trying to discover if there's any configuration which I should to
> do in persistence.xml or there is really any parameter on the
> configuration pool which should I do.
>
>
> Thank you,
>
> Victor
>
>> -----Original Message-----
>> From: Victor Gimenez <victor.gimenez@xxxxxxxxxxxx>
>> Sent: Friday, April 26, 2024 8:47 AM
>> To: Sawamura, Hiroki/澤村 大輝 <sawamura.hiroki@xxxxxxxxxxx>
>> Subject: Re: [glassfish-dev] How to use Glassfish with MySQL or any
>> database instead of Apache Derby
>>
>> Em 2024-04-25 05:33, Hiroki Sawamura (Fujitsu) escreveu:
>>> Hi
>>>
>> Hi!
>>
>>> Humm, it appears that the package of the MySQL implementation class
>>> has
>>> changed.
>>>  - mysql-connector-java-8.0.21.jar:
>>> com/mysql/cj/jdbc/MysqlConnectionPoolDataSource.class
>>> so, the data source class name that should be specified for the JDBC
>>> connection pool is "com.mysql.cj.jdbc.MysqlConnectionPoolDataSource"
>>> instead of "
>>> com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource".
>>>
>> It worked here after that I changed this data source class name!!
>>
>>> I am not familiar with JPA, but for JPA, you would specify the JDBC
>>> resource name as a data source in persistence.xml and then inject its
>>> unit name into EntityManager.
>>> ```persistence.xml
>>> <persistence //snip//>
>>>   <persistence-unit name="MysqlUnit">
>>>     <jta-data-source>jdbc/mysql</jta-data-source>
>>>   </persistence-unit>
>>> </persistence>
>>> ```
>>>
>>> ```java
>>> public class YourAppDao{
>>>     @PersistenceContext(unitName="MysqlUnit")
>>>     private EntityManager em;
>>> ```
>>>
>> I did this modifications here in my persistence.xml file and the .java
>> file which contains the EntityManager em variable declaration and it
>> stayed like that
>> ```
>> persistence.xml
>>
>> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
>> <persistence xmlns="https://jakarta.ee/xml/ns/persistence"
>>               xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>               
>> xsi:schemaLocation="https://jakarta.ee/xml/ns/persistence
>> https://jakarta.ee/xml/ns/persistence/persistence_3_0.xsd"
>>               version="3.0">
>>
>>      <persistence-unit name="default">
>>          <!--transaction-type="JTA"-->
>> <!--
>> <jta-data-source>java:comp/DefaultDataSource</jta-data-source>-->
>>          <properties>
>>              <property
>> name="jakarta.persistence.schema-generation.database.action"
>> value="drop-and-create"/>
>>          </properties>
>>      </persistence-unit>
>>
>>      <persistence-unit name="MySqlUnit">
>>
>> <!--<provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>-->
>>          <jta-data-source>jdbc/mysql</jta-data-source>
>>          <properties>
>>              <!-- connection data -->
>>                      <property name="jakarta.persistence.jdbc.driver"
>> value="com.mysql.cj.jdbc.Driver" />
>>                      <property name="jakarta.persistence.jdbc.url"
>> value="jdbc:mysql://localhost/app?createDatabaseIfNotExist=true" />
>>                      <property name="jakarta.persistence.jdbc.user" value="root" />
>>                      <property name="jakarta.persistence.jdbc.password" value="admin" />
>>          </properties>
>>      </persistence-unit>
>> </persistence>
>> ```
>>
>>
>> ```
>> java
>> ...
>> ...
>> @PersistenceContext(unitName="MysqlUnit")
>>      private EntityManager em;
>> ...
>> ...
>>
>> ```
>>
>> The compilation with maven went good with mvn clear and mvn package
>> working
>>
>> But when I am gonna deploy on Glassfish GUI I am getting:
>>
>> ```
>> Error occurred during deployment: Exception while deploying the app
>> [challenge2] : JNDI lookup failed for the resource: Name: MySqlUnit,
>> Lookup: jdbc/mysql, Type: javax.sql.DataSource -- Lookup failed for
>> jdbc/mysql in
>> SerialContext[myEnv={java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl,
>> java.naming.factory.url.pkgs=com.sun.enterprise.naming}]. Please see
>> server.log for more details.
>> ```
>>
>> I am trying to realize what I am doing wrong!
>>
>>
>> Thank you,
>>
>> Victor
>>
>>> -----Original Message-----
>>> From: Victor Gimenez <victor.gimenez@xxxxxxxxxxxx>
>>> Sent: Thursday, April 25, 2024 4:41 PM
>>> To: Sawamura, Hiroki/澤村 大輝 <sawamura.hiroki@xxxxxxxxxxx>; Glassfish
>>> Dev
>>> <glassfish-dev@xxxxxxxxxxx>
>>> Subject: Re: [glassfish-dev] How to use Glassfish with MySQL or any
>>> database instead of Apache Derby
>>>
>>> Em 2024-04-24 22:13, Hiroki Sawamura (Fujitsu) escreveu:
>>>> Hi
>>>
>>> Hi Hiroki!
>>>>
>>>>> Class name is wrong or classpath is not set for :
>>>>> com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource Please
>>>>> check the server.log for more details.
>>>>
>>>> Oops, I may have forgotten to mention something simple: placing the
>>>> JDBC driver under the lib is to add it to the classpath, so
>>>> DAS(GlassFish) restart is required.
>>>>
>>> I entered sudo ./asadmin restart-domain to restart the DAS(Glassfish)
>>> and I successfully got this return statement:
>>>
>>> ```
>>> Waiting finished after 30 ms.
>>> Server instance is stopped, now we wait for the start on
>>> localhost:4848
>>> ...
>>> Waiting finished after 2,695 ms.
>>> Successfully restarted the domain
>>> Command restart-domain executed successfully.
>>>
>>> ```
>>>
>>> But when I did that ping command the same error persisted, I let the
>>> mysql-connection-java-8.0.21.jar in
>>> /home/victor/Downloads/web-7.0.13/glassfish7/glassfish/domains/domain1/lib/
>>> path.
>>>
>>>>> And about the step 4 referring these code snippets in which .java
>>>>> file should I refer them?
>>>>
>>>> It is simply example of how to reference the JDBC resource within
>>>> your
>>>> Jakarta EE application deployed to GlassFish. It is not a specific
>>>> Java file.
>>>>
>>>>> And this ":" at the final of the code snippet is a ";" or "}" to
>>>>> finish the if block?
>>>>
>>>> No. It indicates that the description of any process would continue
>>>> after that.
>>>>
>>>
>>> Ohhhh now it made sense here to me and I realized, I remembered now
>>> that this DataSource dataSource is a variable responsible for getting
>>> the connection number as true or false to create the statement, and
>>> after query, update, delete and so on... In JPA I am using
>>> EntityManager em variable to make the CRUD operations like
>>> insert(em.persist), list data (em.getCriteriaBuilder().createQuery...
>>> do you know if I can able to use also the @Resource annotation above
>>> EntityManager em declaration?
>>>
>>>
>>>> Hiroki
>>>>
>>>> -----Original Message-----
>>>> From: Victor Gimenez <victor.gimenez@xxxxxxxxxxxx>
>>>> Sent: Thursday, April 25, 2024 3:41 AM
>>>> To: glassfish-dev@xxxxxxxxxxx
>>>> Cc: Sawamura, Hiroki/澤村 大輝 <sawamura.hiroki@xxxxxxxxxxx>
>>>> Subject: Re: [glassfish-dev] How to use Glassfish with MySQL or any
>>>> database instead of Apache Derby
>>>>
>>>> Hello Hiroki! Thanks for your response,
>>>>
>>>>
>>>>
>>>> I did the steps 1, 2 and 3 successfully obtaining as return:
>>>>
>>>> ```
>>>> JDBC connection pool mysql-pool created successfully.
>>>> Command create-jdbc-connection-pool executed successfully.
>>>> ```
>>>>
>>>> Only the connection check with ping returned me:
>>>> ```
>>>> CLI031: Warning: Option "target" is obsolete and will be ignored.
>>>> CLI031: Warning: Option "target" is obsolete and will be ignored.
>>>> remote failure: Ping Connection Pool failed for
>>>> org.glassfish.resourcebase.resources.api.PoolInfo@bad58506[jndiName=my
>>>> sql-pool, applicationName=null, moduleName=null].
>>>> Class name is wrong or classpath is not set for :
>>>> com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource Please
>>>> check the server.log for more details.
>>>> Command ping-connection-pool failed.
>>>> ```
>>>>
>>>> I don't know what is missing in my configurations or if I forgot to
>>>> set anything else.
>>>>
>>>> And about the step 4 referring these code snippets in which .java
>>>> file
>>>> should I refer them? And this ":" at the final of the code snippet
>>>> is
>>>> a ";" or "}" to finish the if block?
>>>>
>>>>
>>>> Thank you,
>>>>
>>>>
>>>> In 2024-04-24 02:56, Hiroki Sawamura (Fujitsu) wrote:
>>>>> Hi,
>>>>>
>>>>> There are 4 simple steps to setting up DB with GlassFish.
>>>>>
>>>>> 1. Place JDBC driver in DAS lib dir.
>>>>>   $ mv mysql-connector-java-XXX.jar
>>>>> glassfish7/glassfish/domains/domains/domain1/lib/
>>>>>
>>>>> 2. Create JDBC connection pool.
>>>>>   $ asadmin create-jdbc-connection-pool \
>>>>>     --restype javax.sql.ConnectionPoolDataSource \
>>>>>     --datasourceclassname
>>>>> com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource \
>>>>>     --property
>>>>> user=your_username:password=your_password:port=3306:databaseName=your
>>>>> _
>>>>> database_name:serverName=localhost
>>>>> \
>>>>>     mysql-pool
>>>>>
>>>>>   It would be a good to check the connection with ping.
>>>>>     $ asadmin ping-connection-pool mysql-pool
>>>>>
>>>>> 3. Create JDBC resource.
>>>>>   $ asadmin create-jdbc-resource --target server --connectionpoolid
>>>>> mysql-pool jdbc/mysql
>>>>>
>>>>> 4. Refer in your application.
>>>>> lookup is no longer needed. it can be easily injected and used with
>>>>> jakarta.annotation.Resource annotation.
>>>>> ```java
>>>>>   @Resource(lookup = "jdbc/mysql")
>>>>>   DataSource dataSource;
>>>>> ```
>>>>> then, describe the operation as follows ```java java.sql.Connection
>>>>> con = dataSource.getConnection(); if (con.isValid(10)) {
>>>>>   java.sql.Statement stmt = con.createStatement();
>>>>>   java.sql.ResultSet result = stmt.executeQuery("SELECT
>>>>> ID,NAME,PROGRAMMING_LANGUAGE FROM DEV")
>>>>> :
>>>>> ```
>>>>>
>>>>> Regards,
>>>>> Hiroki
>>>>>
>>>>> -----Original Message-----
>>>>> From: glassfish-dev <glassfish-dev-bounces@xxxxxxxxxxx> On Behalf
>>>>> Of
>>>>> Victor Gimenez via glassfish-dev
>>>>> Sent: Wednesday, April 24, 2024 3:44 AM
>>>>> To: glassfish-dev@xxxxxxxxxxx
>>>>> Cc: Victor Gimenez <victor.gimenez@xxxxxxxxxxxx>
>>>>> Subject: [glassfish-dev] How to use Glassfish with MySQL or any
>>>>> database instead of Apache Derby
>>>>>
>>>>> Hello there,
>>>>>
>>>>>
>>>>>
>>>>> I am very new to Glassfish and Jakarta EE which I am learning
>>>>> nowadays, I would like to know what I should do to add MySQL or any
>>>>> database instead of Apache Derby which is configured as the default
>>>>> database server? I am very stuck reading the documentation and
>>>>> without know which files should I configure to add.
>>>>>
>>>>>
>>>>> Thanks in advance,
>>>>>
>>>>> --
>>>>> Victor Borghi Gimenez
>>>>>
>>>>>
>>>>> Computer Science M.Sc. - Center for Mathematics, Computing and
>>>>> Cognition
>>>>> - Federal University of ABC (UFABC)
>>>>> System Analysis and Development Technologist - São Caetano do Sul
>>>>> College of Technology (FATEC-SCS)
>>>>> _______________________________________________
>>>>> glassfish-dev mailing list
>>>>> glassfish-dev@xxxxxxxxxxx
>>>>> To unsubscribe from this list, visit
>>>>> https://www.eclipse.org/mailman/listinfo/glassfish-dev
> _______________________________________________
> glassfish-dev mailing list
> glassfish-dev@xxxxxxxxxxx
> To unsubscribe from this list, visit
> https://www.eclipse.org/mailman/listinfo/glassfish-dev
_______________________________________________
glassfish-dev mailing list
glassfish-dev@xxxxxxxxxxx
To unsubscribe from this list, visit https://www.eclipse.org/mailman/listinfo/glassfish-dev

Back to the top