[wdfink]

Look like there are problems with the DS configuration as there is a MySQL Syntax error.

You should check whether the connection work.

A tool to use the JDBC might be SQirreL here you can test with a java program your DB

[joachim.a]

I think I made some progress. Also SQirreL helped to test the connection. Thank You.

In addition, I found out how to generate a packed war (select the AS in the servers tab and press "open"; then, in the Deployment tab, you can specify "Deploy projects as compressed archives").

But nevertheless, I still get an error message "Specified JDBC Driver com.mysql.jdbc.Driver class not found" (see attached log file).

E.g. I configured the jar file in Java Build Path -> Libraries.

Can somebody help?

[kuldeep11]

Have you created MySQL driver module? Please go through doc for configuring DS in AS 7.

Data Source Configuration in AS 7

Thanks!

[joachim.a]

Thanks for the support. Yes, I have done it as described but I assume I've done something wrong/something is missing. Issues which could cause the problem:

- I've done it according "Installing a JDBC driver as a module"; my assumption is that I only have to perform the corresponding steps from this chapter; nothing from "Using @DataSourceDefinition to configure a DataSource"

- I don't understand the statement "In this case, as the case with all JDBC data sources, we would be dependent on the Java JDBC API's, which in this case in defined in another module called javax.api, which you can find under modules/javax/api/main as you would expect." Where I can get the file javax.api; is it essential?

The connection to the data source is working (e.g. test connection in the admin console is working and I tested it with SQuirreLSQL).

I attached the log file.

[kuldeep11]

Seems issue with your persistence.xml  and how you are packaging your build?

I think test your DB connectivity with some small testing app which can help you in troubleshooting. Also if possible, then check by increasing the LogLevel.

[joachim.a]

Thanks for the support.

In fact, it is/was a simple test example.

E.g. I set the log category org.jboss.as.jpa to TRACE but there is no additional information printed out. Which logger category analog level is recommended?

(I also attached the persistence.xml.)

[kuldeep11]

I don't have much experience with development .

Try to put your MySql Connector jar to "modules/org/hibernate/main" and change the module.xml file.

[joachim.a]

Thank You - but no success. I there another idea.

[joachim.a]

any clue? can somebody help?

[joachim.a]

Is there an idea how I can proceed?