Win a copy of The Way of the Web Tester: A Beginner's Guide to Automating Tests this week in the Testing forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Configuring MYSQL Datasource

Rashid Darvesh
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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();
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
and i also changed teh standardjaws.xml to
<type-mapping>Hypersonic SQL</type-mapping>-->
and also standardjbosscmp-jdbc.xml to
<datasource-mapping>Hypersonic SQL</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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic