Just an FYI for those among us using Informix... (I'm using jdbc driver
2.20.JC2)

I set up an Informix db pool in jboss.jcml, and I wanted to use the sqlhosts
file for the connection.  Seemed simple enough, use a URL of the form
"jdbc:informix-sqli:/<dbname>:" and
"informixserver=<dbserver>;SQLH_TYPE=FILE;SQLH_FILE=<local sqlhosts file>"
in the "Properties" attribute for the XADataSourceLoader.  But it kept
hanging JBoss when configuring my pool.  After a very long night and
morning, I discovered the problem was that the sqlhosts file had the port
NAME from /etc/services instead of the port NUMBER(which normally would be
ok for non-jdbc accesses).  When I hard-coded the port NUMBER entry in
sqlhosts, JBoss got through the configuration.

<grumble grumble>stupid Informix jdbc driver</grumble grumble> :)

--
Jim Brownfield
[EMAIL PROTECTED]
Radical System Solutions, Inc.


_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to