[jboss-user] [JBoss Seam] - Mysql Database Connection Problem Seam

[vikramchhetryy]

Hi All,
I am trying to create a new application in seam my problem is that i am not able to connect to the database.

my connection xml looks like this:-
  | <?xml version="1.0" encoding="UTF-8"?>
  | 
  | <!DOCTYPE datasources
  |     PUBLIC "-//JBoss//DTD JBOSS JCA Config 1.5//EN"
  |     "http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd">
  | 
  | <datasources>
  |    <local-tx-datasource>
  |       <jndi-name>AbcDatasource</jndi-name>
  |       <connection-url>jdbc:mysql://127.0.0.1/abc</connection-url>
  |       <driver-class>com.mysql.jdbc.Driver</driver-class>
  |       <user-name>abc</user-name>
  |       <password>xyz</password>
  | <!--
  |       <exception-sorter-class-name>
  |          org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter
  |       </exception-sorter-class-name>
  |       <metadata>
  |          <type-mapping>mySQL</type-mapping>
  |       </metadata>
  | -->
  |    </local-tx-datasource>
  | </datasources>
  | 

The error I get is :-
java.sql.SQLException: Server configuration denies access to data source

I have tried many combinations for mysql connect url like
jdbc:mysql://127.0.0.1:3306/abc

I am using :-
Suse 10.0
mysql4.1
seam2.0
jboss 4.2.2
ant1.6
eclipse europa
mysql-connector-java-3.0.9-stable-bin.jar

i am not sure if i am using right connection jar.

Any help would be appreciated.

Regards, 
Vikram

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4114757#4114757

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4114757