| Thread | Last Post | Replies |
|
| ResultSet has a null value... | 11 Feb 2005 02:54 GMT | 2 |
Hello, I need your help, please... I have a following code in my application: PreparedStatement pstmt = con.prepareStatement( "SELECT * FROM USERS WHERE LOGIN = ?");
|
| White space problems | 10 Feb 2005 23:48 GMT | 8 |
I'm trying to display the rows of a sql database in a web page, but the row called "Bedlington station", having a space in, is causing problems. How do I fix this? I've tried enclosing single quotes in the double quotes,
|
| Sybase, JDBC, AutoCommit, DDL IN TRAN | 10 Feb 2005 21:09 GMT | 3 |
I am hoping someone can help me with the following problem I'm having executing Sysbase stored procedures via JDBC. When I execute a stored procedure which contains DDL and with AutoCommit set to false I get the following exception.
|
| Comparing database dates: SELECT FROM WHERE Date(today) < MYDATECOL ? | 10 Feb 2005 19:06 GMT | 4 |
I want to get in a java prgm all those database records whose MYDATE column contains a date greater equal a given other date (say: today). How do I specify this in a SQL query from Java? Assume the comparison date in java is in a java.util.Date field. Do I have to convert it
|
| jdbc db2 problem with handle image, audio and video | 10 Feb 2005 11:54 GMT | 3 |
I want to handle image, audio and video using jdbc. I have got db2 udb personal edition v.8.1.3 and I don't know what function should I use? StringBuffer sql = new StringBuffer(); sql.append("SELECT picture, voice from employee where id='000001'");
|
| JDBC and Multiple record sets | 09 Feb 2005 04:06 GMT | 3 |
Can JDBC handle multiple record sets in a single callable statement. Thanks in advance.
|
| problem while setting class path.. | 08 Feb 2005 16:51 GMT | 1 |
I have WinNT(2000) and ORacle 9i.. While running a java prg, the following error occured : " java.lang.noclassdeffounderror :org/jdom/Illega lNameException"
|
| linked server referred by insert trigger | 08 Feb 2005 14:26 GMT | 1 |
Hei, We have 2 MS SQL SERVER 2000 installed on 2 different servers (2 separated machines). I am triing to connect them s? that when one row is added to the table in
|
| How to create Microsoft Access Database (.mdb) in Java | 08 Feb 2005 03:43 GMT | 5 |
I want to create a blank Microsoft Access 97 Database in Java and later connect to it and create tables and insert data. I know how to connect to an existing .mdb database, but I have no idea how to create one using Java. Can you help me figure out how to make it. Thank you!
|
| Class.forName hang initializing oracle.jdbc.OracleDriver | 08 Feb 2005 02:40 GMT | 1 |
I have a multi-threaded application that uses both MSDE and Oracle. If I begin processing MSDE transactions and then later call Class.forname( "oracle.jdbc.OracleDriver" ), this call will hang. Why? According to the docs, Class.forName initializes the class, so I'm guessing
|
| SQLUtil static class | 07 Feb 2005 13:15 GMT | 5 |
Hi to everyone, I have to develop a 3-tier web application. The application accesses oracle db. Where can I find a sort of SQLUtil static class in JAVA encapsulating the
|
| Portable way to pass array parameter to a stored proc? | 06 Feb 2005 18:27 GMT | 2 |
I realized that stored proc's are written in proprietary langauges to begin with, but I am wondering if there is a JDBC portable way to pass an argument (in or out) that is an array of some primitive type. I've seen solutions passing delimited strings and parsing that in the proc ...
|
| Overwriting a Access Database using JDBC | 06 Feb 2005 03:35 GMT | 1 |
I am creating a java app that uses JDBC to connect to an Access DB. I am using SQL INSERT statement to add records to my empty DB. But each time I execute my App , my DB keeps on increasing in size. Wht I want is that each time I should execute my app, the initial records be
|
| How to overwrite data in an Access Database uisng JDBC | 04 Feb 2005 23:26 GMT | 2 |
I have connected an Access Database to my Java Application using JDBC connectivity. My problem is that each time I execute my java application, the data gets re-written into the database and the data base just keeps on increasing in size.
|
| Invalid Cursor State when retrieving data from a valid ResultSet - please help! | 04 Feb 2005 20:59 GMT | 8 |
I am going crazy trying to accomplish the simplest of tasks: retrieve data via JDBC. I get a [Microsoft][ODBC Driver Manager] Invalid cursor state SQLException whenever I access the Resultset.get* methods. And, yes, I have remembered to call the .next() method
|