JBoss & MySQL

[rajavee]

Config: WinXP Pro, jboss-3.0.4, Apache-2.0.44, PHP-4.3.0, JConnecto ****

JBoss - starts up with only 1 error, shown below.
- shuts down with no problem.
PHP - successfully access a MySQL database, and is able to query and display data
- succesfully uses java to retrieve functions such as java.version

&java.text.SimpleDateFormat

But I get this error when trying to use jboss to retrieve data from the MySQL

database
Warning: java.lang.Exception: UserClient.getUsers >> exception:
java.lang.reflect.UndeclaredThrowableException in C:\Program Files\Apache Group\Apache2\htdocs\index.php on line 156

[rajavee]

Warning message I get while JBoss starts up14:43:18,343 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean ope
ration 'checkIncompleteDeployments()'
Cause: Incomplete Deployment listing:
Packages waiting for a deployer:

Incompletely deployed packages:

MBeans waiting for classes:

MBeans waiting for other MBeans:
[ObjectName: jboss.jca:service=LocalTxCM,name=jdbc/phpa/Users
state: CONFIGURED
I Depend On: jboss.jca:service=LocalTxDS,name=jdbc/phpa/Users
jboss.jca:service=LocalTxPool,name=PHPaMySQLdbDS
jboss.jca:service=CachedConnectionManager
jboss.security:service=JaasSecurityManager
jboss.jca:service=RARDeployer

Depends On Me: , ObjectName: jboss.jca:service=LocalTxDS,name=jdbc/phpa/Users
state: CONFIGURED
I Depend On: jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC
Wrapper
jboss:service=MySQL

Depends On Me: jboss.jca:service=LocalTxCM,name=jdbc/phpa/Users
]
14:43:18,437 INFO [URLDeploymentScanner] Started
14:43:18,437 INFO [MainDeployer] Deployed package: file:/C:/jboss/server/defaul
t/conf/jboss-service.xml
14:43:18,437 INFO [Server] JBoss (MX MicroKernel) [3.0.4 Date:200211021607] Sta
rted in 0m:33s:47ms

[rajavee]

phpa_mysql-service.xml



<!-- Include a login module configuration named HsqlDbRealm.
Update your login-conf.xml, here is an example for a
ConfiguredIdentityLoginModule:
-->
<application-policy name = "MySQLDbRealm">

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

</application-policy>
<!--
NOTE: the application-policy name attribute must match
SecurityDomainJndiName, and the
module-option name = "managedConnectionFactoryName"
must match the object name of the ConnectionManager you are configuring here.
-->
<!--uncomment out this line if you are using the DB2DbRealm above -->
MySQLDbRealm


<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->


jdbc/phpa/Users


<config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://localhost:3306/mysqldb</config-property>
<config-property name="DriverClass" type="java.lang.String">com.mysql.jdbc.Driver</config-property>
<config-property name="UserName" type="java.lang.String">root</config-property>
<config-property name="Password" type="java.lang.String"></config-property>



<!--Below here are advanced properties -->
<!--hack-->
<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper
jboss:service=MySQL



<depends optional-attribute-name="ManagedConnectionPool">
<!--embedded mbean-->


0
50
5000
15
<!--criteria indicates if Subject (from security domain) or app supplied
parameters (such as from getConnection(user, pw)) are used to distinguish
connections in the pool. Choices are
ByContainerAndApplication (use both),
ByContainer (use Subject),
ByApplication (use app supplied params only),
ByNothing (all connections are equivalent, usually if adapter supports
reauthentication)-->
ByContainer


<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager

<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager

java:/TransactionManager

<!--make the rar deploy! hack till better deployment-->
jboss.jca:service=RARDeployer




<!-- Moved to end to mysqldb anonymous depends -->
<!--

1476
true
default
false

-->

[rajavee]

using mysql-connector-java-2.0.14-bin.jar which is in C:\jdk\jre\lib\ext

[rajavee]

$wddx = $java_obj->getUsers(); is line 156 in index.php