jrun-resources.xml Isolation Level problem

[ProphecyVI]

Attempting to follow the Adobe TechNote at http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=5444c687 creates log lines that imply the process works, but the datasource is not usable via ColdFusion - calling it throws "Datasource DevDB not found". Below are the log lines seeming to imply it does exist. Why can MX 7.0.2 not see it?

11/08 15:43:12 info JRun DataSourceService: Created JDBC XA Connection Pool named DevDB
11/08 15:43:12 info Bound a LinkRef from "DefaultDataSource" to the default DataSource "DevDB"
11/08 15:43:12 info JRun Proxy Server listening on *:51011
11/08 15:43:13 info Deploying enterprise application "Macromedia ColdFusion MX" from: file:/C:/CFusionMX7/
11/08 15:43:13 info Deploying web application "Macromedia Coldfusion MX" from: file:/C:/CFusionMX7/

[tzimmerman]

Create another datasource and select "J2EE Datasource (JNDI)" from the driver dropdown in the administrator if you want to use a datasource that's defined in the jrun-resources.xml file.

Ted Zimmerman

[ksmith]

You must be running the multi-server version or a J2EE version of CFMX7 to have that option.

[ProphecyVI]

So does that mean the TechNote does not apply to CFMX 7 standalone after all? It is not in fact possible to set the isolation level for a CFMX 7 standalone install?

[ksmith]

First, I was wrong about needing the multi-server version of cfmx7 in order to have a "J2EE Datasource (JNDI)" DSN type. It is there in the standalone. Second, this type of datasource will allow you to use your DevDB datasource. Just point to it in your new JNDI DSN. We will update the technote to describe this final step.

[ProphecyVI]

Trying that in the CF administator, I get an error "Data source DevDB not found". However the coldfusion-out.log still shows the same lines that appear to indicate it exists.

[tzimmerman]

Make sure the JNDI name you use in the datasource matches the <jndi-name> in the jrun-resources.xml. Also make sure you restart the ColdFusion server after making any changes in to the jrun-resources.xml file.

You should see a message similar to the following in the {cfmx-root}/runtime/logs/coldfusion-event.log:

JRun DataSourceService: Created JDBC XA Connection Pool named [your jndi-name]

Ted Zimmerman

[ProphecyVI]

The xml file contains:

<data-source>
<dbname>DevDB</dbname>
<driver>com.seefusion.Driver</driver>
<url>
jdbc:seefusion:jdbcwrapper{jdbc:jdbcprogress:T:[url removed]:[port removed]:[db removed]};
</url>
<username>[username removed]</username>
<password>[encrypted pw removed]</password>
<encrypted>true</encrypted>
<encryption-class>
jrun.security.JRunCrypterForTwofish
</encryption-class>
<native-results>true</native-results>
<remove-on-exceptions>true</remove-on-exceptions>
<pool-statements>false</pool-statements>
<initial-connections>1</initial-connections>
<connection-timeout>1200</connection-timeout>
<transaction-timeout>20</transaction-timeout>
<cache-enabled>false</cache-enabled>
<cache-size>5</cache-size>
<cache-refresh-interval>30</cache-refresh-interval>
<jndi-name>DevDB</jndi-name>
<poolname>Pool</poolname>
<minimum-size>0</minimum-size>
<maximum-size>2147483647</maximum-size>
<user-timeout>20</user-timeout>
<skimmer-frequency>420</skimmer-frequency>
<shrink-by>5</shrink-by>
<maximum-soft>true</maximum-soft>
<debugging>false</debugging>
<disable-pooling>false</disable-pooling>
<isolation-level>READ_UNCOMMITTED</isolation-level>
<description/>
</data-source>

The coldfusion-event.log says:

11/10 14:11:28 info JRun DataSourceService: Created JDBC XA Connection Pool named DevDB
11/10 14:11:28 info Bound a LinkRef from "DefaultDataSource" to the default DataSource "DevDB"

But the CFAdmin says:

Error editing/creating this dsn (DevDB)
Data source DevDB could not be found.

[tzimmerman]

I 've tried this with both a standard and enterprise license and it works fine. Why don't you try removing the seefusion wrapper from the url and see if that will work.

Ted Zimmerman

[ProphecyVI]

Okay, I have gotten it to work with some modifications. Removing the SeeFusion wrapper (which is a problem but not one I see a solution to until CF8) and setting encrypted to false. No matter how many times I copy the password from neo-query.xml into jrun-resources.xml, it throws the following error. By setting encrypted to false in jrun-resources.xml and using an unencrypted password, the process works.

Error with encrypted true:

11/10 16:36:42 error Encountered the following error while initializing JDBCPool: {0}
java.lang.ArrayIndexOutOfBoundsException: 6
at jrun.security.Twofish_Algorithm.blockDecrypt(Twofish_Algorithm.java:572)
at jrun.security.JRunCrypterForTwofish.decrypt(JRunCrypterForTwofish.java:86)
at jrun.sql.pool.JDBCPool.create(JDBCPool.java:551)
at jrunx.pool.ObjectPool.checkOut(ObjectPool.java:242)
at jrunx.pool.ObjectPool.init(ObjectPool.java:73)
at jrun.sql.pool.JDBCPool.init(JDBCPool.java:166)
at jrun.sql.pool.JDBCPool.<init>(JDBCPool.java:89)
at jrun.sql.pool.JDBCManager.createPool(JDBCManager.java:53)
at jrun.sql.management.DataSourceService.start(DataSourceService.java:75)
at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at jrun.deployment.resource.ResourceDeployer.startDataSources(ResourceDeployer.java:225)
at jrun.deployment.resource.ResourceDeployer.start(ResourceDeployer.java:84)
at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at jrunx.kernel.ServiceAdapter.invokeMethod(ServiceAdapter.java:705)
at jrunx.kernel.JRunServiceDeployer.invokeOnServices(JRunServiceDeployer.java:460)
at jrunx.kernel.JRunServiceDeployer.startServices(JRunServiceDeployer.java:312)
at jrunx.kernel.JRunServiceDeployer.startLifecycle(JRunServiceDeployer.java:260)
at jrunx.kernel.JRunServiceDeployer.deployServices(JRunServiceDeployer.java:87)
at jrunx.kernel.DeploymentService.loadServices(DeploymentService.java:46)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at jrunx.kernel.JRun.startServer(JRun.java:575)
at jrunx.kernel.JRun.<init>(JRun.java:493)
at jrunx.kernel.JRun$1.run(JRun.java:346)
at java.security.AccessController.doPrivileged(Native Method)
at jrunx.kernel.JRun.start(JRun.java:343)
at jrunx.kernel.JRun.startByNTService(JRun.java:427)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at jrunx.kernel.JRun.invoke(JRun.java:180)
at jrunx.kernel.JRun.main(JRun.java:168)