Cant figure why I cant run this example

[rvince99]

I am trying to deploy an application that utilizes Struts & Spring & JPA & Hibernate as found and detailed at the Apache site:

http://struts.apache.org/2.0.12/docs/struts-2-spring-2-jpa-ajax.html

I think there must be something missing in that article (particularly to configuring for mysql ) When I create my war file and go to deploy it, I get the JBoss trace below -- can anyone tell me, from that, what I am missing or need to do? Somehow, I smell I dont have things configured properly for mysql, though I have followed everything in that article. -R. Vince

---JBOSS Trace -----

11:19:45,281 INFO [TomcatDeployer] deploy, ctxPath=/ssa, warUrl=.../tmp/deploy/
tmp57256ssa-exp.war/
11:19:46,921 INFO [WebappClassLoader] validateJarFile(G:\jboss-4.2.3.GA\server\
default\.\tmp\deploy\tmp57256ssa-exp.war\WEB-INF\lib\servlet-api.jar) - jar not
loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Serv
let.class
11:19:47,453 INFO [[/ssa]] Initializing Spring root WebApplicationContext
11:19:47,468 INFO [ContextLoader] Root WebApplicationContext: initialization st
arted
11:19:47,515 INFO [XmlWebApplicationContext] Refreshing org.springframework.web
.context.support.XmlWebApplicationContext@4cb3a4: display name [Root WebApplicat
ionContext]; startup date [Sat Nov 15 11:19:47 EST 2008]; root of context hierar
chy
11:19:47,625 INFO [XmlBeanDefinitionReader] Loading XML bean definitions from S
ervletContext resource [/WEB-INF/applicationContext.xml]
11:19:47,781 INFO [XmlWebApplicationContext] Bean factory for application conte
xt [org.springframework.web.context.support.XmlWebApplicationContext@4cb3a4]: or
g.springframework.beans.factory.support.DefaultListableBeanFactory@14e1705
11:19:48,546 INFO [DefaultListableBeanFactory] Pre-instantiating singletons in
org.springframework.beans.factory.support.DefaultListableBeanFactory@14e1705: de
fining beans [org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostP
rocessor#0,personService,entityManagerFactory,dataSource,transactionManager,org.
springframework.aop.config.internalAutoProxyCreator,org.springframework.transact
ion.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transa
ction.interceptor.TransactionInterceptor#0,org.springframework.transaction.confi
g.internalTransactionAdvisor,personAction]; root of factory hierarchy
11:19:48,656 INFO [DriverManagerDataSource] Loaded JDBC driver: com.mysql.jdbc.
Driver
11:19:49,078 INFO [LocalContainerEntityManagerFactoryBean] Building JPA contain
er EntityManagerFactory for persistence unit 'punit'
11:19:49,125 INFO [Version] Hibernate EntityManager 3.2.1.GA
11:19:49,140 INFO [Version] Hibernate Annotations 3.2.1.GA
11:19:49,156 INFO [Environment] Hibernate 3.2.4.sp1
11:19:49,171 INFO [Environment] hibernate.properties not found
11:19:49,171 INFO [Environment] Bytecode provider name : javassist
11:19:49,187 INFO [Environment] using JDK 1.4 java.sql.Timestamp handling
11:19:49,421 INFO [Ejb3Configuration] found EJB3 Entity bean: quickstart.model.
Person
11:19:49,453 INFO [Configuration] Reading mappings from resource : META-INF/orm
.xml
11:19:49,453 INFO [Ejb3Configuration] [PersistenceUnit: punit] no META-INF/orm.
xml found
11:19:49,531 INFO [AnnotationBinder] Binding entity from annotated class: quick
start.model.Person
11:19:49,593 INFO [EntityBinder] Bind entity quickstart.model.Person on table P
erson
11:19:49,781 INFO [ConnectionProviderFactory] Initializing connection provider:
org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider
11:19:49,796 INFO [InjectedDataSourceConnectionProvider] Using provided datasou
rce
11:19:49,953 WARN [SettingsFactory] Could not obtain connection metadata
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password
: YES)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3649)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1176)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2558)
at com.mysql.jdbc.Connection.(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:266)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnec
tionFromDriverManager(DriverManagerDataSource.java:174)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnec
tionFromDriver(DriverManagerDataSource.java:165)
at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.get
ConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.get
Connection(AbstractDriverBasedDataSource.java:119)
at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.get
Connection(InjectedDataSourceConnectionProvider.java:47)
.
.
.

[jaikiran]

Looks like the user/password credentials specified in your datasource file (*-ds.xml) are incorrect. Can you post the contents of that file?

While posting the logs or xml content or code, remember to wrap it in a code block using the Code button in the message editor window and please hit the Preview button to make sure your post is correctly formatted

[rvince99]

I am using the default installation for mysql, root/root on localhost.

\server\default\deploy\mysql-ds.xml is:

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

<!-- $Id: mysql-ds.xml 71535 2008-04-01 07:05:03Z [e-mail] $ -->
<!-- Datasource config for MySQL using 3.0.9 available from:
http://www.mysql.com/downloads/api-jdbc-stable.html
-->


<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://127.0.0.1:3306/quickstart</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
root
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<!-- should only be used on drivers after 3.22.1 with "ping" support
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
-->
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->
<!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->

<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->

<type-mapping>mySQL</type-mapping>

</local-tx-datasource>



There is also a WEB-INF/application-context.xml, which has connection info as:

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd">


























<tx:annotation-driven transaction-manager="transactionManager" />


<constructor-arg ref="personService" />



//THANKS!

[rvince99]

I am using the default installation for mysql, root/root on localhost.

\server\default\deploy\mysql-ds.xml is:

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

<!-- $Id: mysql-ds.xml 71535 2008-04-01 07:05:03Z [e-mail] $ -->
<!-- Datasource config for MySQL using 3.0.9 available from:
http://www.mysql.com/downloads/api-jdbc-stable.html
-->


<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://127.0.0.1:3306/quickstart</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
root
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<!-- should only be used on drivers after 3.22.1 with "ping" support
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
-->
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->
<!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->

<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->

<type-mapping>mySQL</type-mapping>

</local-tx-datasource>



There is also a WEB-INF/application-context.xml, which has connection info as:

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd">


























<tx:annotation-driven transaction-manager="transactionManager" />


<constructor-arg ref="personService" />



//THANKS!

[rvince99]

I am using the default installation for mysql, root/root on localhost.

\server\default\deploy\mysql-ds.xml is:

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

<!-- $Id: mysql-ds.xml 71535 2008-04-01 07:05:03Z [e-mail] $ -->
<!-- Datasource config for MySQL using 3.0.9 available from:
http://www.mysql.com/downloads/api-jdbc-stable.html
-->


<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://127.0.0.1:3306/quickstart</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
root
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<!-- should only be used on drivers after 3.22.1 with "ping" support
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
-->
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->
<!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->

<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->

<type-mapping>mySQL</type-mapping>

</local-tx-datasource>



There is also a WEB-INF/application-context.xml, which has connection info as:

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd">


























<tx:annotation-driven transaction-manager="transactionManager" />


<constructor-arg ref="personService" />



//THANKS!

[jaikiran]

"RVince99" wrote:
I am using the default installation for mysql, root/root on localhost.

By default, the password is empty of a "root" user on MySQL http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html

Accounts with the username root are created. These are superuser accounts that can do anything. The initial root account passwords are empty, so anyone can connect to the MySQL server as root — without a password

So change you datasource to pass an empty password:

<user-name>root</user-name>
 <password></password>

Based on my previous experience with this, i think even this won't work probably because of the way "empty" password is handled. In that case, change the password of the "root" user on the DB server by following the MySQL documentation. After the password is changed, use that password in the -ds.xml file.

P.S: While posting the logs or code or xml content, remember to wrap it in a code block using the Code button in the message editor window and please hit the Preview button to make sure your post is correctly formatted

[rvince99]

Sorry, wasn't using the code button preoperly, myu apologies. I do have it set to root/root in the mysql-ds.xml....so this should run then, yes?

:

<user-name>root</user-name>
 <password>root</password>

[peterj]

Is "root" the password for the "root" account for your installation of MySQL? If is it not, change it to what the password is. The MySQL installer (on both Windows and Linux) will ask for you to give a password to the root account.

[rvince99]

thanks Peter. Maybe not...I am using MySQL from an installation of InstantRails -- and perhaps I am wrong about that. If I set up a new username/password for localhost in mysql, then the only place I need to specify that in this app would be mysql-ds.xml, yes? I will try that in a few hours when I get back to that system, on the road here right this moment. Thank you so much.

[peterj]

Yes, whatever username/password you set up in mysql to access the database is what goes into the *-ds.xml file.

When I set up a database in MySQL I usually also create a new user account to manage that database and I use that database name and account/password in *-ds.xml.

[rvince99]

How then do I specify mutliple potential db's, say, for mysql? I may have different WARs that require access to different mysql db's?

[peterj]

Use multiple *-ds.xml files, one for each database. An alternative is to provide several local-tx-datasource entries in a single *-ds.xml file, but having a *-ds.xml file per database is preferred.

[rvince99]

Yes, that WAS the problem (though, I don't see how you were able to discern that from the stack trace). Now, when I go to deploy, I get a stack trace telling me it cannot find spring.jar, though I HAVE spring.jar in /WEB-INF/lib :

18:15:27,140 ERROR [[/ssa]] Exception starting filter struts2
Cannot locate the chosen ObjectFactory implementation: spring - [unknown locatio
n]
at org.apache.struts2.config.BeanSelectionProvider.alias(BeanSelectionPr
ovider.java:224)
at org.apache.struts2.config.BeanSelectionProvider.alias(BeanSelectionPr
ovider.java:195)
at org.apache.struts2.config.BeanSelectionProvider.register(BeanSelectio
nProvider.java:153)
at com.opensymphony.xwork2.config.impl.DefaultConfiguration.reload(Defau
ltConfiguration.java:131)
at com.opensymphony.xwork2.config.ConfigurationManager.getConfiguration(
ConfigurationManager.java:52)
at org.apache.struts2.dispatcher.Dispatcher.init_PreloadConfiguration(Di
spatcher.java:395)
at org.apache.struts2.dispatcher.Dispatcher.init(Dispatcher.java:452)

Isn't it enough that a required jar file be in /WEB-INF/lib ? Thanks again.

[peterj]

I do not know anything about Struts2, so I probably cannot help with this.

Yes, having spring.jar in WEB-INF/lib is sufficient, provided that the class wanting to access it (the Struts2 BeanSelectionProvider class in this case) is also located in the same WEB-INF/lib.

Are you sure that when it is identifying "spring" that it specifically means spring.jar? Is it possible that somewhere the term "spring" is configured in a Struts2 config file (or annotation) but that the object/entity "spring" is not defined anywhere?

[rvince99]

Peter, Your latest post got me thinking that perhaps I WAS missing a jar, and sure enough, I was: struts2-spring-plugin-2.0.12.jar
The darn thing works, and I am entirely indebted to your good mind and tenacity. Thank you SO much for working through this with/for me! -Ralph Vince