initial configuration - any help?

[ldolling]

Hi,

problem: datasource not bound

installed:
JBoss 3.2,x
MySQL

1) I can connect to MySQL via JDBC and JBoss directly. Tested. Works fine.
2) Now I want to configure JBoss (default) access MySQL via JNDI and the JBoss datasource configuration.

Problem:
I get exception: "MySqlDB not bound"

Code:
ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("MySqlDB");
conn = ds.getConnection();

What I did:
1) QuickStart-30x.pdf, Chapter 10
2) copying examples\jca\mysql-ds.xml to deploy
3) editing the attributes to my needs (see below). Tested with direct access to MySQL
-> doesn't work
4) figured out HyperSonice example uses a security realm (also refered to in Docu), so I
a) added security realm to mysql-ds.xml
b) added security realm to login-config.xml and set it to NoTxCM (see below)
c) set standardjaws.xml and standardjbosscmp-jdbc.xml
java:/MySqlDB
<datasource-mapping>mySQL</datasource-mapping>

Still it doesn't work. Maybe someone has a general overview how to configure a datasource?

Regards, Lars


----
mysql-ds.xml:

<local-tx-datasource>
<jndi-name>MySqlDB</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/test</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>

<min-pool-size>0</min-pool-size>
<max-pool-size>100</max-pool-size>
<security-domain>MySqlDbRealm</security-domain>
</local-tx-datasource>


login-config.xml
<application-policy name = "MySqlDbRealm">

<login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
<module-option name = "principal">root</module-option>
<module-option name = "userName">root</module-option>
<module-option name = "password"></module-option>
<module-option name = "managedConnectionFactoryName">jboss.jca:service=NoTxCM,name=MySqlDB</module-option>
</login-module>

</application-policy>

[jonlee]

It is not clear from where you are trying to connect to the datasource. If you are trying to connect to the datasource from a remote client, in a VM separate to the JNDI, you will not be able to access the datasource.

See this thread.

http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=

[ldolling]

No, I'm in the VM of JBoss. I'm trying to access the datasource from a class called by a servlet. I check the connection to the datasource in the System.out which displays in the JBoss console.

So, I know the database is running. Because I try the same twice. One class connecting to the database by calling the driver directly and the other via JNDI. Both at the server vm.

So, it looks like I'm simply not able to configure JNDI right?

Lars

[ldolling]

Ok, I fixed the problem. Looking at http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t= I recognized it wasn't a problem with JBoss but with my code. I was porting it from another app server, and I didn't keep in mind that the JNDI variables in JBoss where named differently! So after changing the call to java:/... it worked.

Lars