hello everybody,
I am facing some difficulty in connecting to Db2 database from Jboss..
Can anybody help me with the following issue..
I wanted to connect to DB2 database from the Jboss Server..(Earlier we are able to connect to oracle)
I am getting an error Invalid Argument Type SQLSTATE Hy009.I belive this is some thing to do with the driver..
I am sending you an attachment of the Configuration file that helps to connect to database..
================
<?xml version="1.0" encoding="UTF-8"?>
<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->
<!-- $Id: db2-ds.xml,v 1.1.2.1 2003/09/05 16:38:24 patriot1burke Exp $ -->
<local-tx-datasource>
<jndi-name>ctdb</jndi-name>
<connection-url>jdbc:db2://sjmemcrp2:50000/cris3</connection-url> ( sjmemcrp2 is the server where Db2 is residing,50000 is the default port where the database is and cris3 is the database name)
<driver-class>COM.ibm.db2.jdbc.net.DB2Driver</driver-class>(i tried the other option jdbc.app instead of jdbc.net)
<user-name>db2admin</user-name>
db2admin
<min-pool-size>0</min-pool-size>
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->
<!-- sql to call on an existing pooled connection when it is obtained from pool
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->
</local-tx-datasource>
=====================
The app server is never returning back to me sometimes..I mean it is trying to access the database for ever..
Can anybody pl take a look at the configuration file and let me know what's going wrong?
Anticipating your reply