Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Configuring MYSQL Datasource

 
Rashid Darvesh
Ranch Hand
Posts: 189
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
i am trying to get a hold of mysql datasource and it throws a NameNotBoundException.
here is the code snippet which i am using

Hashtable default_properties = new Hashtable();
default_properties.put(Context.INITIAL_CONTEXT_FACTORY,"org.jnp.interfaces.NamingContextFactory");
default_properties.put(Context.PROVIDER_URL,"localhost:1099");
Context context = new InitialContext(default_properties);
DataSource ds = (DataSource) context.lookup("java:/MySqlDS");
java.sql.Connection con = ds.getConnection();

the following is the mysql-ds.xml file
<datasources>
<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/mysql</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>danira</password>
</local-tx-datasource>
</datasources>
and i also changed teh standardjaws.xml to
<!--<datasource>java:/DefaultDS</datasource>
<type-mapping>Hypersonic SQL</type-mapping>-->
<datasource>java:/MySqlDS</datasource>
<type-mapping>mySQL</type-mapping>
and also standardjbosscmp-jdbc.xml to
<!--<datasource>java:/DefaultDS</datasource>
<datasource-mapping>Hypersonic SQL</datasource-mapping>-->
<datasource>java:/MySqlDS</datasource>
<datasource-mapping>mySQL</datasource-mapping>
and copied the mysql-connector-java...jar file under lib folder
and also added an application policy for MsSqlDbRealm in login-config.xml
Could figure what else exactly i need to do.
the last thing i have to mentionis that i have a CMP which uses this datasource and it works but when i want to grab aconnection using this datasource it doesn't. i hope it is clear
Thanks
RASHID
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic