javaee tutorial: i'm stuck!

[Khaoz]

I'm trygin to do the steps described here:

http://java.sun.com/javaee/5/docs/tutorial/doc/bnaff.html

To deploy the bookstore1 application, but:

[Khaoz]

If i use

ant && ant deploy

Everything build and deploy without problems...

[pmanop]

I found the solution.

[robertgp]

I just solved this problem. I decided to join the forum and share the solution with everybody.

Let's go!

Right-click the "bookstore1" project in the Projects tab and click the option "Open Required Projects". The project "bookstore" will be opened. Build the "bookstore" project. If that didn't turn out, add TopLink Essential Libraries (they were included in my case). Then, build and deploy "bookstore1" project. It should work.

The next problem you may have to deal with, is setting up the DB connections. This doesn't have to do with the message but I think it may be useful for you.

Setting up the DB

- Go to the "Services" Tab.
- Make sure GlassFish V2 is started.
- Click "Databases", and right-click "Java DB".
- Select "Create Database"
- Introduce a Database Name ("BookDB", e.g.) and a UserName and Password (whatever you want)
- Refresh the "Databases" (right-click, Refresh)
- Right-click the Database you just created
- Select "Execute command..."
- Paste "tutorial.sql" contents and execute the script

Setting up Connection Pool and JDBC Resource

- Go to the Admin Console of GlassFish (http://localhost:4848)
- Log in (generally: admin / adminadmin)
- Go to: Resources --> JDBC --> Connection Pools
- Create a New One (e.g. TutorialPool)
- Resource Type: javax.sql.DataSource
- Properties (ServerName: localhost; PortNumber: 1527; User: the one you introduced; Password: the one you introduced; DatabaseName: BookDB)
- You can PING the DB and check if the connection pool is correctly set up
- Go to: Resources --> JDBC --> JDBC Resources
- Create a New One with the name "jdbc/BookDB" use the TutorialPool you created.

Setting up the persistence.xml file

- Go to "bookstore" (NOT bookstore1) Project
- Go to Source Packages --> META-INF --> persistence.xml

This worked for me:

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
<persistence-unit name="book" transaction-type="JTA">
<provider>oracle.toplink.essentials.PersistenceProvider</provider>
<jta-data-source>jdbc/BookDB</jta-data-source>
<class>com.sun.bookstore.database.Book</class>
</persistence-unit>
</persistence>


I expect this is useful for you. Sorry for my crummy English.

Greetings,

Robert

[tomFinegan]

Thank you, Robert. I also was stuck.

I would like to add a couple points:

In the NetBeans Services Tab -
Call your database "bookDB", so it matches some hard-coding in the servlets. I don't know if this is critical, but this way does work.

In the persistence.xml -
Be careful to match the data source exactly to what you see in the JDBC Resources on your server admin page. If it is "bookDB" and NOT "jdbc/bookDB" you should follow suit in persistence.xml

<jta-data-source>bookDB</jta-data-source>

Press on!