Re: setting up the connection pool in netbeans for informix database

hmm not really assume that User" value="bpadmin" Password" value="pass" is correct, can you try this using dbaccess ->> connection--> user bpadmin -->passwd pass also did you check if your informix jdbc driver is in your path... you could goto the examples and see/test if you can get that to work.... hmmm may be when you try to a onstat -m you may see error 952 in the log meaning that the user/passwd is not correct. this: Cause: java.lang.StringIndexOutOfBoundsException cannot be cast to java.sql.SQLException" is very weird, sounds like maybe driver not in classpath??? Superboer. On 15 mei, 15:59, La Farfalla <sjkoa2003MA...@yahoo.com.au> wrote: > 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.

The connection string is correct, I can connect to my database and I've checked if my informix jdbc driver is in the classpath. Everything is correct. My SQL query is also correct, so I guess I'm in the blind street. I really don't know what is wrong, I even don't have any idea what should I try next.