Top "Jdbc" questions

The infamous java.sql.SQLException: No suitable driver found

I'm trying to add a database-enabled JSP to an existing Tomcat 5.5 application (GeoServer 2.0.0, if that helps). The app itself talks …

postgresql tomcat jdbc geoserver

How to get all table names from a database?

I'd like to retrieve all table names from a database schema, and, if possible, get all table starting with a …

java database jdbc database-metadata

PreparedStatement setNull(..)

Java PreparedStatement provides a possibility to explicitely set a Null value. This possibility is: prepStmt.setNull(parameterIndex, Types.VARCHAR); Are …

java jdbc prepared-statement

Where's my invalid character (ORA-00911)

I'm trying to insert CLOBs into a database (see related question). I can't quite figure out what's wrong. I have …

java oracle jdbc prepared-statement

How to execute .sql script file using JDBC

Possible Duplicate: Running a .sql script using MySQL with JDBC I have an SQL script file which contains 40-50 SQL …

java jdbc

ORA-12516, TNS:listener could not find available handler

My error: java.sql.SQLException: Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available …

java oracle jdbc axis2

How to convert Blob to String and String to Blob in java

I'm trying to get string from BLOB datatype by using Blob blob = rs.getBlob(cloumnName[i]); byte[] bdata = blob.getBytes(1, (…

java jdbc blob

Iterating over ResultSet and adding its value in an ArrayList

I am iterating over an ResultSet and trying to copy its values in an ArrayList. The problem is that its …

java jdbc resultset loops

SQLException: No suitable driver found for jdbc:derby://localhost:1527

I get this error in Netbeans: java.sql.SQLException: No suitable driver found for jdbc:derby://localhost:1527/ How is this …

java jdbc derby

Using prepared statements with JDBCTemplate

I'm using the JDBC template and want to read from a database using prepared statements. I iterate over many lines …

java spring jdbc prepared-statement jdbctemplate