getConnection « Development « Java Database Q&A





1. JDBC getConnection timeout issue    stackoverflow.com

I have an application that uses connection pooling to get database connection from oracle9i release 9.2.0.4 database.Application is hosted in SJSAS 8.1 and the driver is ojdbc14.jar version 10.1.0.4. The problem ...

2. How to set a getConnection() timeout for c3p0?    stackoverflow.com

Yesterday AWS's RDS went down -- and so did our database. When this happened, C3P0 would try to get a database connection and would hang. I would obviously like ...

3. Is the syntax of the url for getConnection() method in jdbc correct?    bytes.com

I am using Microsoft Access as datasource to connect to java and I hava a database called test.mdb.. I want to connect to this db using java .. I am having ...

4. The getConnection method is trying to ruin my life!    coderanch.com

My question is not a profound one, I just want to know how to get this method to work. I'm running Windows 2k trying to connect to a DB2 server. Right now I'm just trying to get sample code to work, but I guess I must be using the driver improperly or something because it just won't work no matter what ...

5. Properties for getConnection?    coderanch.com

I did end up finding my answer. . . Essentially, I had run across something that suggested I needed to pass in a property other than username or password (property was SelectMode for the SQL Server 2000 database), but I was having difficulty finding documentation for that property. I'm using a connection pooling mechanism provided by some in-house libraries, so haven't ...

6. JDBC getConnection question    coderanch.com

I'm new to JDBC and I do need help... I'm on a Win 2000 platform trying to access a MS Access database called Manual. I've went into the ODBC DataSource Administrator and created a ODBC MS Access setup for the database, now I'm trying to get a connection to the database via a JAVA application ( As shown below ). I'm ...

7. Should getConnection() be placed in Init() ?    coderanch.com

Hi, I wonder whether Should getConnection() be placed in Init() of a servlet in the situation that multiple users concurrently access DB using service method. My though is, if we place getConnection() in Init() and dbConn is member variable instead of local variable then multiple users have to share a single connection to database. This is resource saving but user will ...

8. How to use the getConnection() method?    coderanch.com

Hi Stu, Thanks a lot for the response. I went to the site you gave me and tried whatever they have specified. (I am using SQLServer 2000). Even before using the getConnection method I am getting the exception. That means I am getting the exception in the class load. The try catch block for the Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver") throws the following exception. ------------------------------------------------------------------------- ...

9. Syntax of getConnection() method    coderanch.com

Hi, The following is the exception. ---------------------------------------------- java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to conn ect. Invalid URL. at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source ) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at UBDAO.main(UBDAO.java:41) Error Trace in getConnection() : [Microsoft][SQLServer 2000 Driver for JDBC]Unab le to connect. Invalid URL. ------------------------------------------------------------------------ The problem is with the syntax where I am giving the ...





10. DB pooling getConnection() return Null    forums.oracle.com