Java Database Connectivity (JDBC)

Tags: java, Java Database Connectivity (JDBC)
  • Splash Screen In Java
  • Sat, 24 Dec 2011 05:26:00 GMT
  • How to create a Splash Screen in java.. Itz better, you can teach it for me using NetBeans......
  • servlet connectivity with JDBC-ODBC
  • Thu, 17 Feb 2011 22:00:00 GMT
  • i m trying to connect one servlet program with type-1 drive i.e JDBC-ODBCusing dsnbut it is giving exception likeException=java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedhowever same dsn works while connecting the swing form with dat...
  • HOWTO update a TEXT column in MySQL
  • Sun, 09 Jan 2011 17:50:00 GMT
  • I would like to see an example of updating a TEXT column from a Java character buffer using the JDBC....
  • HOWTO update TEXT column (a blob) using JDBC
  • Sun, 09 Jan 2011 13:34:00 GMT
  • Need example of updating a TEXT (blob) in MySQL from a Java character buffer....
  • Use java program to access & copy AS400 file to SQL server database/table
  • Mon, 24 May 2010 11:23:00 GMT
  • I need a java program that will access an as400 file and copy it to a database/table in sql server. can you provide a template? ...
  • Java program to copy as400 file to sql server database/table
  • Mon, 24 May 2010 11:30:00 GMT
  • Please, i need a java program to copy data from as400 to sql server database/table. This will be done on the sql server side accesing the as400. The program needs to be able to limit the number of records copied. ...
  • How I insert image in MS ACCESS in Java?
  • Tue, 01 Jun 2010 13:42:00 GMT
  • Pls anybody help me. how  I insert image in Ms Access with JFileChooser.   ...
  • How to return Map<String, List<Long>> from oracle function/procedure?
  • Tue, 15 Jun 2010 00:31:00 GMT
  • I have written a java function which queries a table in database. I am manually creating the List<Long> for each primary key. Instead of hitting database for every primary key, I was thinking if I can write this into a oracle procedure/function. But I am not sure whether Oracle procedure can...
  • Resultset returns nothing despite table having data
  • Wed, 07 Jul 2010 10:55:00 GMT
  • Hello, I am using RAD 7.5 with webshpere 7 app server. I have a table witha a BLOB column which I have to read in my code. I am simply doing a select column name from tablename where id='abc'   When I run rs.next() it throws arrayIndexOutOfBoundsException. When I run the same qu...
  • i have to run a query using jdbc fr ms access
  • Wed, 28 Jul 2010 05:00:00 GMT
  • hi. i have to run the following query using jdbc for msaccess select deptname,deptid,sum(sal),sum(arrears) from dept group by deptname,deptid; m not able to run this.please suggest as to what to do.....
  • I get this error - java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few paramete
  • Wed, 25 Aug 2010 01:17:00 GMT
  • I get this error - java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.When i connect to an access database of two column, Time & amount. The time entry is fine, but no entry for the amount.try {Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")...
  • face too few paramerters when i connect advance java to access
  • Wed, 25 Aug 2010 01:22:00 GMT
  • I get this error - java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.When i connect to an access database of two column, Time & amount. The time entry is fine, but no entry for the amount.try {Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");S...
  • connection failed to firebird
  • Mon, 01 Nov 2010 05:59:00 GMT
  • Hi, I try to create a JDBC provider under websphere 7. when testing datasource connection, I hae the following error, can you help please. [01/11/10 11:41:24:500 CET] 00000015 DataSourceCon E   DSRA8040I: Failed to connect to the DataSource.  Encountered "": java.sql.SQ...
  • jdbc-wrapper
  • Mon, 19 Apr 2010 01:54:00 GMT
  • hi, can anyone explain the difference between jdbc and the wrapper ? i have read that wrappers contain jdbc...so, what are wrappers for, except they contain jdbc? thanks in advance...
  • insert arraylist in mysql using java
  • Tue, 27 Apr 2010 12:45:00 GMT
  • Hiii,           I want to store an arraylist or array into mysql table..explanation is i have to store number of id_s in a cell of a mysql table using java. what will be the datatype of this array in mysql and what should be the code to insert this arraylist object in...
  • hi everybody, i m using tomcat5.5 & oracle 10g then how connectivity will be done with oracle10g
  • Thu, 08 Apr 2010 08:03:00 GMT
  • thanks in advance...
  • how can connect Tomcat5.5 & oracle10g
  • Thu, 08 Apr 2010 09:00:00 GMT
  • Hi, I am using tomcat5.5 and oracle10g on xp2 OS with jdk1.5.<br />i want to run simple jdbc servlet program but i found an error message as resource is not available<br />guide me.<br /><br /><br />Thanks<br /><br /><br /><br /><br />...
  • How can connect Tomcat5.5 & oracle10g?
  • Thu, 08 Apr 2010 09:07:00 GMT
  • <br />How can connect Tomcat5.5 and oracle10g?<br />...
  • How can connect Tomcat5.5 & oracle10g?
  • Thu, 08 Apr 2010 09:07:00 GMT
  • <br />How can connect Tomcat5.5 and oracle10g?<br />...
  • rolling back stored procedures
  • Mon, 02 Nov 2009 08:28:00 GMT
  • Hi,I just have the same problem as you.I have to call multiple stored procedures, and I'm not able to roll them back.did you managed to do it?thanks....
  • rolling back stored procedures
  • Mon, 02 Nov 2009 08:28:00 GMT
  • Hi,I just have the same problem as you.I have to call multiple stored procedures, and I'm not able to roll them back.did you managed to do it?thanks....
  • Zipping Up BLOBs in the Database
  • Sun, 23 Sep 2007 22:50:00 GMT
  • HiI am trying to zip up existing BLOB files in the database, and when I do it, it just returns a bunch of unreadable garbage.. I have attached the code below, its a bit complicated, and I was wondering if anyone of you would know what I am doing wrong or is there an easier way to do this? ...
  • zipped EBCDIC in DB2
  • Wed, 16 Jul 2008 19:49:00 GMT
  • Has anyone extracted zipped EBCDIC i.e. zipped mainframe data into a websphere java application? We believe the content is being converted to ASCII - which we need to disable.TIA...
  • ZIP v/s JAR
  • Sun, 10 Feb 2008 15:30:00 GMT
  • hello,I've just seen that in addition to having a classes12.zip, there is a classes12.jar (usual java JAR file) in ORA_HOME/jdbc/lib.Does anyone know why the JAR is present?cheers,Vx...
  • Zip Exception while connecting thru JNDI
  • Wed, 16 Jul 2008 19:53:00 GMT
  • hello there,While i am trying to connect oracle thru JNDI, i was getting javax.naming.NamingException- unable to create resourse instance. I thought the server may not be able to read the zip file.Hence, I have unzipped classes12.zip and copied OracleDriver.class into my application directory un...
  • ZHT16DBT - UNICODE convertion in JAVA
  • Sat, 09 Feb 2008 23:43:00 GMT
  • Please help me how to make string convertion between different code.I have a database in ZHT16DBT code. How to convert the ZHT16DBT code to UNICODE in Java when doing any query statement from that database.the following is the code i tried, but not workint oracleID=CharacterSet.ZHT16DBT_CHARSET;...
  • zero vs nothing in an integer field accessed with ResultSet.getInt()
  • Wed, 14 Nov 2007 16:00:00 GMT
  • I'm currently working with a DB that has int fields with both nothing and zero (0) and the two different values mean different things. No value means no measurements were taken and 0 means a measurement of zero.If I use ResultSet.getInt() on this field I get "0" for both cases. Is there a way ...
  • Zero rows returned with JdbcOdbcDriver to MS Sql 2000
  • Thu, 15 Nov 2007 09:57:00 GMT
  • This code always returns 0 rows. There is plenty of data in the MS SQL 2000 Customers table.package DBTests;import javax.swing.*;//import javax.sql.*;import java.sql.*;import java.io.*;import java.lang.*;public class DBTests {public static void main(String[] args)//throws SQLException, ...
  • Zero resultset for MYSQL despite data in tables
  • Thu, 15 Nov 2007 06:15:00 GMT
  • I've been getting zero for all my query result sets even though my database is not empty. I don't know if the problem lies with my servlet code or my resin deployment. Can someone tell me what's wrong?Here's part of the codes.Login.javapublic class Login extends HttpServlet {final String ...
  • Z/OS Java under WLM stopped working
  • Tue, 25 Sep 2007 11:55:00 GMT
  • We are running WBIFN 1.1 on Z/OS 1.4. It uses DB2 V7 at RSU0512. The java runs under stored procedures, was working at install, but now we get:java.lang.ExceptionInInitializerErrorHere are the full messages:DSNX961I DSNX9WLS ATTEMPT TO PERFORM JNI FUNCTION FindClass 576FAILED FOR STORED ...
1537153815391540154115421543
  • Java Technology Blogs
  • "Java Database Connectivity (JDBC)" Related Questions
  • Paged Result Set
  • Does Oracle allows to retrive the first n rows or second rows for a single sql query like the LIMIT,OFFSET clause of the POSTGRE Object RDBMS. Or is it possible to set the rows returned by a sql to be first n rows or 2nd n rows through Java's JDBS.?null...
  • ResultSets from Java Stored Procedures
  • I have seen several questions asked about Java Stored Procedures returning ResultSet Objects. Any official words on how it can be done.I already have a PL/SQL REF CURSOR example, but I am looking for a full JAVA example (including the SPEC to convert the Java Class to a PL/SQL stored procedure)S...
  • MySQL returning results based on dates
  • Hi all,I'm making a system which returns names of people who are free on certain days, and then prints their contact details, and books them for user selected days.The employee clicks on days which are then stored into an availability table in the format day, month and year as separate int ...
  • Accessing SQL Object type
  • I have to access SQL object types. One approach I know is to implement the SQLData interface and create classes for the type objects.Is there any other mechanism to access ?One simple way I see is using STRUCT. But I have nested Structures. Whether it is possible to retrieve all the attributes i...
  • different value in Windows XP & Windows 2000 in saving in Database Probel
  • Hello to all,Can you help me on my problem, I have an application that connects to the PostgreSQL database, When I save a japanese text using Windows XP, it will save it correct in the database. But when I retrieve it using Windows 2000, the japanese where garbage.When I input japanese text ...
  • jdbc driver version
  • Hi, There are various versions of jdbc driver provided by oracle. I would like to know if the highest version is compatible with lower version.That is to say,I can use 10g driver to connect 8.1.7,9i,10g. And I want to know the performance between these versions and java versions. Thanks.wy....
  • JDBC SQL server date format problem
  • in my application i am using JDBC ODBC bridge to connect to the SQL server database.its a JSP appication.when i insert date to database it gets inserted in the format of mm/dd/yy but when i display it in the next page through resultset using getString method it displayes in the format of yy/mm/d...
  • create proc(edure) statement with parameters on Access db
  • I try to add a stored proc(edure) with parameters to an Access database, but I just don't get it done. I know Access doesn't support real stored procedures, but the same syntax can be used to add (parametrized) queries. I use this code:import java.sql.*;class SPTest {public static void ...
  • Hello, all. I have a problem - I'm trying to ...
  • Hello, all. I have a problem - I'm trying to write my first program by Java2and need to connect applets with database in MySQL. Don't know how to dothat. I know, that I have to use a driver, but what exactly and where can Itake it? Thank you....
  • no JdbcDomino in java.library.path
  • Hi, I recently started a small web-app that needs to extract data from a lotus domino server. I installed the jdbc driver provided by IBM and had the lotus notes/client installed on the same machine as the app-server, and the CLASSPATH is pointing to the jdbcdomino.jar file. Essentially I've ...