setting up the connection pool in netbeans for informix database

Posted in 2008

Topics: Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing, Java & JDBC Development, Cloud, Docker & Containers, Internationalization & Character Sets

La Farfalla — Wed, 14 May 2008 13:10:52 +0200 — source: Usenet: comp.databases.informix

Hello! I have trouble with setting up the connection pool for informix database in netbeans ide 6.0.1 I've found netbeans tutorial which explains how to set up the connection pool for mysql database. I followed the steps from tutorial,but it doesn't work for informix database. I have index.jsp page on which I have drop-down list which should be filled in with data dynamically. First error I've received was: javax.servlet.ServletException: javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: Error in allocating a connection. Cause: Class name is wrong or classpath is not set for: com.informix.jdbc.IfxDataSource" I've solved this by adding the ifxjdbcx.jar to my project's library. But, the second error I don't know how to handle: javax.servlet.ServletException: javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: Error in allocating a connection. Cause: java.lang.StringIndexOutOfBoundsException cannot be cast to java.sql.SQLException" This is the part of web.xml file: <resource-ref> <description>jdbc:informix-sqli://192.168.242.131:9088/ifxdatabase:INFORMIXSERVER=ifx01</description> <res-ref-name>jdbc/IfxDatabase</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> <res-sharing-scope>Shareable</res-sharing-scope> </resource-ref> And this is the content of sun-resources.xml file: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE resources PUBLIC "-//Sun Microsystems, Inc.//DTD Application Server 9.0 Resource Definitions //EN" "http://www.sun.com/software/appserver/dtds/sun-resources_1_3.dtd">; <resources> <jdbc-resource enabled="true" jndi-name="jdbc/IfxDatabase" object-type="user" pool-name="IfxDatabasePool"> <description/> </jdbc-resource> <jdbc-connection-pool allow-non-component-callers="false" associate-with-thread="false" connection-creation-retry-attempts="0" connection-creation-retry-interval-in-seconds="10" connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0" connection-validation-method="auto-commit" datasource-classname="com.informix.jdbcx.IfxDataSource" fail-all-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="false" is-isolation-level-guaranteed="true" lazy-connection-association="false" lazy-connection-enlistment="false" match-connections="false" max-connection-usage-count="0" max-pool-size="32" max-wait-time-in-millis="60000" name="IfxDatabasePool" non-transactional-connections="false" pool-resize-quantity="2" res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1" steady-pool-size="8" validate-atmost-once-period-in-seconds="0" wrap-jdbc-objects="false"> <property name="URL" value="jdbc:informix-sqli://192.168.242.131:9088/ifxdatabase:INFORMIXSERVER=ifx01"/> <property name="User" value="bpadmin"/> <property name="Password" value="pass"/> </jdbc-connection-pool> </resources> I can't find what is wrong. I would appreciate very much if someone could give me any advice. Thanks in advance.

↪ replying to La Farfalla

Superboer — Thu, 15 May 2008 05:30:08 -0700 (PDT) — source: Usenet: comp.databases.informix

try: jdbc:informix-sqli:// 192.168.242.131:9088:INFORMIXSERVER=ifx01;database=ifxdatabase Assume that your database is called ifxdatabase Superboer. On 14 mei, 13:10, La Farfalla <sjkoa2003MA...@yahoo.com.au> wrote: > Hello! > > I have trouble with setting up the connection pool for informix database > in netbeans ide 6.0.1 > I've found netbeans tutorial which explains how to set up the connection > pool for mysql database. I followed the steps from tutorial,but it > doesn't work for informix database. > > I have index.jsp page on which I have drop-down list which should be > filled in with data dynamically. > > First error I've received was: > javax.servlet.ServletException: javax.servlet.jsp.JspException: Unable > to get connection, DataSource invalid: "java.sql.SQLException: Error in > allocating a connection. Cause: Class name is wrong or classpath is not > set for: com.informix.jdbc.IfxDataSource" > > I've solved this by adding the ifxjdbcx.jar to my project's library. > > But, the second error I don't know how to handle: > javax.servlet.ServletException: javax.servlet.jsp.JspException: Unable > to get connection, DataSource invalid: "java.sql.SQLException: Error in > allocating a connection. Cause: > java.lang.StringIndexOutOfBoundsException cannot be cast to > java.sql.SQLException" > > This is the part of web.xml file: > > <resource-ref> > <description>jdbc:informix-sqli://192.168.242.131:9088/ifxdatabase:INFORMIXSERVER=ifx01</description> > <res-ref-name>jdbc/IfxDatabase</res-ref-name> > <res-type>javax.sql.DataSource</res-type> > <res-auth>Container</res-auth> > <res-sharing-scope>Shareable</res-sharing-scope> > </resource-ref> > > And this is the content of sun-resources.xml file: > > <?xml version="1.0" encoding="UTF-8"?> > <!DOCTYPE resources PUBLIC "-//Sun Microsystems, Inc.//DTD Application > Server 9.0 Resource Definitions //EN" > "http://www.sun.com/software/appserver/dtds/sun-resources_1_3.dtd">; > <resources> > <jdbc-resource enabled="true" jndi-name="jdbc/IfxDatabase" > object-type="user" pool-name="IfxDatabasePool"> > <description/> > </jdbc-resource> > <jdbc-connection-pool allow-non-component-callers="false" > associate-with-thread="false" connection-creation-retry-attempts="0" > connection-creation-retry-interval-in-seconds="10" > connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0" > connection-validation-method="auto-commit" > datasource-classname="com.informix.jdbcx.IfxDataSource" > fail-all-connections="false" idle-timeout-in-seconds="300" > is-connection-validation-required="false" > is-isolation-level-guaranteed="true" lazy-connection-association="false" > lazy-connection-enlistment="false" match-connections="false" > max-connection-usage-count="0" max-pool-size="32" > max-wait-time-in-millis="60000" name="IfxDatabasePool" > non-transactional-connections="false" pool-resize-quantity="2" > res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1" > steady-pool-size="8" validate-atmost-once-period-in-seconds="0" > wrap-jdbc-objects="false"> > <property name="URL" > value="jdbc:informix-sqli://192.168.242.131:9088/ifxdatabase:INFORMIXSERVER=ifx01"/> > <property name="User" value="bpadmin"/> > <property name="Password" value="pass"/> > </jdbc-connection-pool> > </resources> > > I can't find what is wrong. I would appreciate very much if someone > could give me any advice. Thanks in advance.

↪ replying to Superboer

La Farfalla — Thu, 15 May 2008 15:59:24 +0200 — source: Usenet: comp.databases.informix

Superboer wrote: > try: > > > jdbc:informix-sqli:// > 192.168.242.131:9088:INFORMIXSERVER=ifx01;database=ifxdatabase > > > Assume that your database is called ifxdatabase > > > Superboer. > > I've tryed jdbc:informix-sqli://192.168.242.131:9088:INFORMIXSERVER=ifx01;database=ifxdatabase, as you suggested, instead of jdbc:informix-sqli://192.168.242.131:9088/ifxdatabase:INFORMIXSERVER=ifx01, but I'm still receiving the same error: javax.servlet.ServletException: javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: Error in allocating a connection. Cause: java.lang.StringIndexOutOfBoundsException cannot be cast to java.sql.SQLException" Do you have any other suggestion? Thanks for trying to help me.