This content has been marked as final.
Show 7 replies
-
1. Re: Database connectivity error
sherkan777 Jul 7, 2009 9:00 AM (in response to hubaghdadi)post your db conf.
-
2. Re: Database connectivity error
hubaghdadi Jul 7, 2009 10:48 AM (in response to hubaghdadi)The datasource file:
<datasources> <local-tx-datasource> <jndi-name>SmsBulkSendDatasource</jndi-name> <use-java-context>false</use-java-context> <connection-url>jdbc:mysql://domain/appdb?characterEncoding=utf-8</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <user-name>smsbulk_user</user-name> <password>pass</password> </local-tx-datasource> </datasources>
persistence.xml:
<persistence-unit name="SmsBulkSend" transaction-type="JTA"> <provider>org.hibernate.ejb.HibernatePersistence</provider> <jta-data-source>SmsBulkSendDatasource</jta-data-source> <properties> <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect"/> <property name="hibernate.hbm2ddl.auto" value="update"/> <property name="hibernate.show_sql" value="true"/> <property name="hibernate.format_sql" value="true"/> <property name="hibernate.cache.provider_class" value="org.hibernate.cache.HashtableCacheProvider"/> </properties> </persistence-unit>
-
3. Re: Database connectivity error
sherkan777 Jul 7, 2009 11:22 AM (in response to hubaghdadi)What is your db driver?
Read your error msg
Apparently wrong driver class specified for URL
-
4. Re: Database connectivity error
hubaghdadi Jul 7, 2009 11:39 AM (in response to hubaghdadi)mysql-connector-java-5.1.6-bin.jar
-
5. Re: Database connectivity error
sherkan777 Jul 7, 2009 1:08 PM (in response to hubaghdadi)and driver jar is in
<jboss AS>/server/default/lib
-
6. Re: Database connectivity error
sherkan777 Jul 7, 2009 1:11 PM (in response to hubaghdadi)nah,
Is what is thisdomain
first try to connect without encoding like this:
<connection-url>jdbc:mysql://localhost:3306/test</connection-url>
-
7. Re: Database connectivity error
hubaghdadi Jul 7, 2009 1:13 PM (in response to hubaghdadi)Thanks.