i have a table with different values and a date (e.g. 523 ; 12.06.2001). i want to read the value and the date, put it in a list and increment the date. now i want to read the value of the new date. it's everything working fine, but when there are no entries with the new date, i get an ...

HiWhich is better to use when retrieving rows from a database for processing (max 100 rows): Vectors or Array Lists?

hi all,I am looping through a ResultSet to set properties of an Class(cl). Then I add each class to the vector(vt) by casting the cl into Object. But when I try to retrieve elements from the vector. I only get one element as though all the elements in the vector are occupied by only one ...

I am facing problem.I am using jdbc odbc bridge and sql server as database.what i am trying to do is as follows:stmt=dbCon.createStatement();rs=stmt.executeQuery(Select * from A.....);while(rs.next()){rs1=stmt.executeQuery(Select * from B.....);\\......int ff=stmt.executeUpdate("insert into ...

Hi,I am developing a database management package for mysql. I want to be able to provide a sql dump facility, which will produce the sql code for creating a table and populating it.I do not seem to be able to find a function for identifying if a field is auto-incrementing?The only thing that I ...

hello there...this is the snipet of my code... here " Applet " is trying to make a connection with the " MSSQL " ...Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");Conncetion c = DriverManager.getConnection("jdbc:odbc:192.168.0.6&test", "myname", "mypassword");here test is the DSN - it is ...

I experience a very slow performance for jdbc-odbc using ms access as the database. This program works fine with other computer (in term of performance). However, the harddrive is cranking big time with this computer (this is the fastest one among the computers I tested, and also has many ...

Hi !I'm experiencing problem with my current Access connection.It's working for a while but causes an error.I'm using this code:Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;String url = "jdbc:odbc:DNS_name" ;Connection con = DriverManager.getConnection( url , "" , "" ) ;Statement stmt = ...

Hi all,I have a strange problem. This might sound really simple, but, I couldn't figure out the solution and thought, may be some one else can help me out.The problem is, when I'm trying to execute a query, which actually does a join of tables A (id, name, grade) & B (id, name, balance), ...

Hi everybodyI'm trying to connect to a remote ms SQl database residing on the server.I tried the below given code but got the error "java.sql.SQLException: No suitable driver"Code :String conString = "jdbc:odbc:DRIVER={sun.jdbc.odbc.JdbcOdbcDriver};SERVER=64.162.55.102;"+ ...

I'm a pretty tech guy and after hours of searching on the web, I find it pretty frustrating that there doesn't appear to be a way to convert a MS Access DB to mySQL...for use in my JDBC application.Several apps I downloaded didn't work and I found a VB script that reported errors that ...

Hello all.Is it possible to access the Oracle Database located in the server using Applet...And also my means of ThindriverCan anyone help me.Thx in advancemailto :contact_geeth@yahoo.comSunx

Hi again all,Can I use the JDBC to ODBC bridge to connect to a Sybase database? If so are there any disadvantages/drawbacks on doing?Tnahks

I wanted to use oracle stored function in my programme(inserts/update the data into multiple tables based certain values in related tables). I need to pass many values from java to calling function is there any way to pass my java values into oracle function as an array of values or by any ...

I have a static method which increments a number in a database then selects it, this method is used by multiple threads.public static synchronized int getNextNumber(Connection con)throws SQLException{ con.setAutoCommit( false ); try {//create statment//increment number//select ...

Hi all!I tried to make a little app in order to practice RMI and JDBC. A little swing app displays ImageIcon from local files and store/retrieve these Images to/from an RMI server.Everything goes fine when storing the data ( at least no exception is thrown ). Though when I try to unMarshall ...

From various days I am searching for one solution...I have to create an application in JSP on a Linux server. Details at the address: http://www.ileda.it/question.asp Thanks!!email: caaib@tin.it

I have a triggers in my Oracle table. The triggers accept a global ID to stored to it's table. How could I do it in Java using JDBC?

I am accessing a FileMaker Pro 5.5 Database using the jdbc-odbc Bridge. When I do a getString() on a ResultSet, I only get the first 255 chars. The type of my column is "TEXT".

Hi. this throws a NegativeArraySizeException on executeBatch:con.setAutoCommit(false);PreparedStatement p=con.prepareStatement("insert test_date(txt) values(?)");p.setString(1, "das");p.addBatch();p.setString(1, ...

I have queries which take 30+ seconds to complete when called by the client. The queries return a large result set, number of rows. The queries actually only takes less than two seconds. It is populating the CORBA structs that is taking all the time. Any ideas on how to improve? An exampleis ...

Hi all. I have a 3 tier client server app that I am having some problems with. I use the JDBC and RMI API's. I am using JDK1.1.8 (neccessary). My problem is this. I have clients dialling in the server a varying times of the day. I have set autoCommit to false, and commit my transaction if ...

Hi,We are developing an intranet / internet application using Websphere's Visual Age on an Oracle database.Does anybody have an idea on what the below error message means "JTS/JTA transaction has been aborted".This is a SQLException thrown when the "javax.sql.datasource.getConnection(username, ...

The question is: for example, a school teachs six courses: c1,c2,c3,c4,c5,c6. All the students must take all the six courses. The possible grades of every course are: A,B,C,D. I want analyze the performance of the students.For example:How many student can get the grades: ...

Hi every expert,I had a problemabout chinese charset.I retrieved the chinese data from oracle db using JDBC thin driver.The output format likes "0xE999B3E7A78BE6B19FE38080E38080E38080".I think it is the problem of the charset conversion.I put the part of the program:*The part of the connection ...

hi, i am trying to insert a blob and clob into the oracle db. both are read correctly but when i try to write them, exceptions are thrown. here is the code.// function to insert a clob public void writeCLOB(long contentId, String meta, Connection con) {String data = null;PreparedStatement ps = ...

Hi, Can anybody tell me whether I can use Java to program the database operations for SQL Server CE?

HiIs the jdbcodbc bridge stable enough to be used in a commercial application? I've heard there are lots of bugs in it yet everyone still seems to use it!I need to connect to a MS SQL Server 2000 and need to find a good stable driver.Thanks.

I have a stored procedure with datetime parameter. But when I use CallableStatement to set parameter, I can only find setTimestamp. In fact, I can execute the Stored Procedure successfully, but I find the value in the result table is stored without 'seconds'.For example:passed value: ...

Hi ,I need some clarification regarding resultset access. 1.If we have a resultset and while looping thru the resultset, we use the same connection to execute another query(without closing the previous resultset) , can we still use the previous result set.2. I tried some sample code and i was ...

Hello all:I am facing a tiny problem. I have a string to Insert into the database. The string contains a '. (say today's). Class.forName(driver_name).newInstance();Connection connectiondB = DriverManager.getConnection("jdbc:odbc:DBASE");Statement statementdB = ...

Hi all, does any one knows how do I identify the primary key column(s) when a ResultSet is given?Thanks.

Using Weblogic 6.0 sp2.I have a session bean with a save method marked as transaction RequireNew.The session bean calls 2 methods (parent insert, child insert) on an entity bean with transaction Mandatory.The entity bean methods both obtain a database connection using JNDI.If I have autoCommit ...

I'am facing problem in connecting to Oracle 8i server using oci8 JDBC driver provided by Oracle.The statemnet that gives me error is --Connection conn = DriverManager.getConnection ("jdbc:oracle:oci8:@" + "MIS", "scott", "tiger");This throws an exception java.lang.UnsatisfiedLinkError : ...

HiI tried to execute following code,i got problem:Statement stmt;ResultSet rs = stmt.executeQuery("select *......"); how can i check whether any record return or not any record return.thanks

I have a problem with the following sql-statement:SELECT dbo_V_Traffic.Datum, Sum(dbo_V_Traffic.Anzahl) AS anzahl_sum FROM dbo_V_Traffic WHERE (((dbo_V_Traffic.Land)=3) AND ((dbo_V_Traffic.Referer) LIKE 'aperto')) GROUP BY dbo_V_Traffic.DatumThe problem is the word 'like'. Is there another ...

hi can u please tell me how i can get no of rows from a result set..i am using thin drivers and connecting to remote database,every thing is working fine if i use fwd only type ,but if u use sensitive type it is giving error ...

Hi,I have a servlet that uses JDBC to connect to Access and reads a table. I need to display the data retrieved from the table on an HTML screen in editable mode. In othe words, the user should be able to change the data that I display on the screen, eg., updating user profile. I am doing the ...

HiI am using servlets to connect to a database and display it in the form of HTML table. I need to assign a radio button to each row. This table contains around 100 rows. THe radio button should be a column before "Name". How can I assign a radio button to each row without doing 100 times like ...

I am taking in a date on my jsp form in 3 drop down lists, year, month and day. I now want to enter this date into the my database in the following format mm/dd/yyyy.What would be the best way to do this?Thanks in advance!

HiI have a problem with the sentence setBlob(int, Blob)I m working with SqlServer 2000 and odbc of Windows 2000, the sentence setBlob cause a Exception :java.lang.UnsupportedOperationExceptionis this problem of database ?or driver ?

Hello,I want to connect to a Lotus Notes Database file through a server on UNIX (AIX), but I can't seem to find a suitable JDBC Driver to let me talk with the database. Does there exist a JDBC Driver for Lotus Domino/Notes on a Unix based platform? If so, what is it, and what path should that ...

Hi all:Does Java SQL have a method to find the relation between tables?ThanksPrashanth

Hi, Please can someone help me I am desperately trying to fix my code for a nested query, I have the following code but get the following error message [i] SQLException message given: Syntax error or access violation: You have an error in your SQL syntax near 'Test11 T2 where S = subj' at ...

Hi,I've got a weird problem going on with an application I'm writing. I hope someone can tell me what I'm doing wrong.The problem I'm encountering is in he code shown below. The function getAllGamesForATeam is creating a list of items in an ArrayList and passing it back to an Event handler ...

OK, I'm starting to think nobody is doing this. I wish to have a DB2 UDB on AIX listen for calls from JDBC on my web server which is Apache-Tomcat on Win95. I'm using a Merant pure Java driver and I get "error creating socket: connection refused" errors when I try to talk to the AIX box via ...

HiI'm having a problem validating myself to a MySQL database. I know that the parameters I'm passing are correct (the mysql shell utility accepts them).Could somebody please tell me what's wrong with the follwing code:import java.sql.*;public class TestConn { public static void main(String[] ...

Can anyone help me with this error?blob.java:6: Public class OracleBLOB must be defined in a file called "OracleBLOB.java"I am so new to Java that I cannot debug too well. Any suggestions are very much appreciated.

Well Guys, I'm very new to Java Tech & i'm sorry for posting my query in this section.I wanna know, how can i store my resultset in an Array.I would like to dislay it afterwards.I'm using MySQL Database.I wud really appreciate the help by all techies present over here. ...

hi this may be easy for some/all.....let me know how to do...thisI had a servlet that uses JDBC to connect to Access and reads a table. I need to display the data retrieved from the table on an HTML screen in editable mode.The user should be able to change the data that I display on the screen, ...