Stackoverflow, I need your help.
I am developing a J EE application, but I came across a road block. I am currently setting up the environment to use IBM DB2 Express-C and WASCE on Windows 7 with the Eclipse Juno J EE version. Both technologies work fine, I can access WASCE through a browser, and I can access a DB2 instance through Data Studio 3.1.1, and I can access existing databases and create schemas, tables, execute queries ...
My problem occurs when I try to create a data connection profile through Eclipse so that I can use the JPA tools to reverse engineer the schema. So, I create a connection profile with Jars from Ex-c ( db2jcc.jar , db2jcc_license_cu.jar ) and the following properties:
Connection URL: jdbc:db2://localhost:50000/DBNAME Database Name: DBNAME Driver Class: com.ibm.db2.jcc.DB2Driver Password: **** User ID: USERNAME Test Connection Result: "Ping Succeeded!"
So, I am in order and now the connection profile is created. So, I click twisty and see DBNAME, select DBNAME, select "Directories", "DBNAME", "Schemas" ...
and nothing!
I open SQL Scrapbook, execute a simple query: "Select * from schema.table" and I will return the result, which is the correct data that I entered into the database through Data Studio.
So, I'm trying to use JPA Tools, and, as I already guessed, it does not register tables through the connection profile, so it does not work. Also, when creating a JPA, my entities (made by hand) shout at me because they say that the table does not exist and the fields do not match. Or something like that.
I need your help to establish the correct connection profile through Eclipse Juno Java EE with DB2 Exc!