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

Deep_Edward do-not-reply at jboss.com
Tue Jul 17 02:54:33 EDT 2007


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:

  |     <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.


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

More information about the jboss-user mailing list