[jboss-user] [Datasource Configuration] - Re: Error when making mysql as the default datasource

[Deep_Edward]

Hi,

The above mentioned query has been solved and the data is saved(i.e. gets persistent) in the MySql table created when the JBoss server is started.

The user has to create a database 'jboss' in MySql  and grant ALL privileges to it. 

In mysql-ds.xml (in  /server/default/deploy/)make the following changes:

<datasources> 
  |     <local-tx-datasource> 
  |         <jndi-name>MySqlDS</jndi-name> 
  |         <connection-url>jdbc:mysql://localhost:3306/jboss</connection-url> 
  |         <driver-class>com.mysql.jdbc.Driver</driver-class> 
  |         <user-name>jboss</user-name> 
  |         <password>password</password> 
  |     </local-tx-datasource> 
  | </datasources> 

Now the server is configured with mysql as the default database.
  

 Deep

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

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