DB Connection Exception in Multithreaded code

[Roshini Sridharan]

Hi,

There's a multithreaded code that creates N no. of threads, each thread creates a new DB Connection instance to connect to a DB using JDBC. So there are N no. of individual connections to the database created by each thread. In this context find that when one of thread is being created and it tries to get the DB Connection the below Exception is being throwed.

As per the exception, find its relevant to the JDBC URL formation. Please note the method that obtains the DB Connection is a synchronized one.

	at java.lang.Thread.run(Thread.java:571)
Caused by: java.sql.SQLException: invalid arguments in call
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
	at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
	at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:183)
	at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346)
	at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
	at java.sql.DriverManager.getConnection(DriverManager.java:559)
	at java.sql.DriverManager.getConnection(DriverManager.java:189)
	... 9 more

Would like to know the possible cause for this and the possble solution like implementing colleection pooling would help.

Thanks in advance.

Regards
Roshini

[Ammar Shah]

Reasons for "invalid arguments in call" usually are around invalid
configuration (URL, user/pwd).

[Roshini Sridharan]

Hi,

Can someone provide me some insight into this issue.

Thanks.