Hey ppl,I have a major problem with transactions. Im doing a DBMS with my application connecting to MS Access2000.The problem ive got is that i cant execute more than one transaction. For example, if my gui has 2 buttons, and both execute a transcation each when pressed. If the first button is ...

I need to connect to an excel file with a DSN-LESS connection, something like this:"jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=C:\..."The error message that I get is "DATA SOURCE NAME TOO LONG".I read in documentation and I found that this error is happen because the setting of ...

Hi,I am using JDK 1.4 on win2000, and I am updating an MS sql 7 server via JDBC (JdbcOdbcDriver that is shipped with 1.4 version).The problem I encounter (with no reasonable reason) is that even though I insert strings that are shorter than the max length of the field, in the table I see them ...

I have to connect to Oracle 8i using ODBC. Question: Do I need Oracle client installation on my machine if I want to connect to the database via ODBC. OR Have you tried any ODBC to connect to Oracle which can work without an Oracle Client installation ( no tnsnames.ora). This would help me. ...

I am doing a research programming project that convert a database file to another database format(for ex: MS Access type to Oracle).Can anybody tell me how can i do that? For now, i am looking at the JDBC 2.0 API to get the database metadata from databases. That's should work fine. One problem ...

String update = "INSERT INTO Test_Table (Html) VALUES (updatestring)";I am using these query in a program in which i am retreiving some data modifying it and inserting back into the database. updatestring is a variable which contains the modified string to be inserted back into the database. ...

String update = "INSERT INTO Test_Table (Html) VALUES (updatestring)";I am using trying to write a query in a program, in which i am retreiving some data modifying it and inserting back into the database. updatestring is a variable which contains the modified string to be inserted back into the ...

I want to connect to SQL Server 7.0 through Java. What is the JDBC Driver available for SQL Server? I can connect by creating a DSN in my machine, but I want to use the JDBC connectivity. Where can I find the documentation for the connectivity to SQL Server?

are there any free JDBC drivers out there? if so, where and are they stable with fast connections. thanx in advance.

Is it possible to work with two recordsets in one method?If so, I havnt been able to figure out how.Any Suggestions?Stef

I am trying to connect to the database throw oci8with the jsdkee1.3 and I get the next error ERROR in serviceBySession java.security.AccessControlException: access denied(java.lang.runtimePermission loadLibrary.ocijdbc8)by the way I have no problem with thin driver only with oci8.does anyone ...

New to JDBCI am trying to connect to PostgreSQL DB using JDBC and the driver supplied with Red Hat Distribution. I view env variables and see that the driver is in the classpath(CLASSPATH=/usr/lib/pgsql/jdbc7.0-1.2.jar).example of error:>javac DBConnect.Java>java DBConnectException in ...

Hi,I'm not even sure if this problem is Java related, butif I anyone can help me I would really appreciate it.I'm designing a JSP interface to an Access database,which stores progress reports and their information.When a user submits a report, there is a field in thetable which is of type ...

Hi i many must be having this problem while inserting a string with a single quote in it.E.g "Didn't".The solution i came across was to write a code to replace that single quote with two quote...ie. "Didn''t" .But I am wondering that JDBC doesn't have any such statement or methods which ...

hi allcan anyone suggest me with the code to make connectivity of our JDBC driver with sql server...thanks in advance

I have downloaded the evaluation copy of Merant MS SQL driver.I have downloaded to a directory in my c: drive and unjarred the files.I have included the mssequel.jar file in my JDk 1.3 lib.I am using Jrun a.d MS SQL 2000.Now when I am trying my code Connection ...

I am trying to learn quickly and want to write a tag to pull info from a DB to a page.?

I have downloaded the JSQLCOnnect JDBC Driver from Netdirect..I am using MS SQL 2000 ....Allire JRUn and JDK 1.3I am trying to update the resultset..my code isStatement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);String strSQL= "SELECT * FROM [" + ...

I want to access a MS Access DB file on a local machine. I will never need to access it remotely!!. I want to be able to save all the data caputred in a java standalone into the file. I will need to show that the app would be easy to install onto other computers however from what I understand ...

i need to use java to access a MS Access database, locally and remotely. is the bridge better with 97, 2000, or 2002? or will i need to use something other than the bridge? also can i use PC Anywhere to access this database remotely? TIA.

I had made the connection thru JDBC and was able to access data from MS Access database when i had written java application program. But when i created one applet and created instance of that class which was making connection to the database thru JDBC and called one method which was returning ...

HI,I have installed MySQL and the Mark Matthews' MySQL JDBC Driver Version 0.9e.It works fine on basic stuff but I want to get adventurous and do scrollable ResultSets.Does anyone know for sure if this driver does or does not support this feature? I've looked through the documentation for a ...

Hi All,I have 3 databases, and I need to get selective data from 2 databases and insert into the tables in the 3rd. Data to be filled in a table in the 3rd database can be from one table in the 1st database and another table in the 2nd database. What is the efficient method to do this? Thanks ...

Hi,I want to connect to an OLAP server and execute multidimentional queries using Java. Can anyone tell me if and how this can be done?Does JDBC2.0 support this?Regards,

Hi FriendsWhat is "Connection Pooling"I am developing Java Application using ms sql server 2000 databasePl explain me about thisthanxinadvanceyoursRajesh

Hi,how can I get DB2 Decimal values into Java BigDecimal values. ResultSet offers a getBigDecimal method, but where can I put the value ? Creating a new BigDecimal is not possible, only String, BigInteger, double. getDouble causes rounding problems.Andreas

helloi am trying to call stored procedure from javabeans to SQL server database.my stored procedure is.....=========================================CREATE PROCEDURE sp_ins_client1_defect /* INSERTS defect AFTER GENERATING A NEW defectidRETRUN VALUES -1) -101 inser failed2) 0Successfull*/@status ...

Good morning,Can someone help me get this to run? When I run the CreateCoffees java tutorial I get the following:C:\jdk1.3.1\bin>java CreateCoffeesClassNotFoundException: centura.java.sqlbase.SqlbaseDriverSQLException: No suitable driverI have the SqlbaseDriver on my d:\Centura\java\sqlbase ...

I am trying to create a JDBC object layer over the database back-end for use by J2EE webapps. On updates to the database, I need to ensure that the row has not been updated by another user in the interm since I read it from the database. All of our tables already have certain "audit" columns ...

HiI need to get the autonumber of the inserted row on MS Access 97I use PreparedStatement ps = con.prepareStatement(insertString);ps.executeUpdate();ps.close();Your help is appreciated

Hi All!Getting this message, followed by SQLException, while in the client app I'm trying to obtain a connection via DataSource.SQLException has no code, status or msg ( 0, null and ""respectively).Environment:J2EE RI v 1.3 with Cloudscape ( standard shipping).Database ( CloudscapeDB) exists ...

I've made a simple applet that use jdbc bean componend to make a connection to mysql database and show result in a jtable.If I run the Applet on the Forte editor all its fine, for run the application alone in appletviewer i've make a package with ...

I've made a simple applet that use jdbc bean componend to make a connection to mysql database and show result in a jtable.If I run the Applet on the Forte editor all its fine, for run the application alone in appletviewer i've make a package with ...

Okay this is the first time I've ever tried to create a database. I'm not sure how to get started. Do I need anything extra that's not in the JDK? Do I need to specially configure anything?

How do I open and close a database ?How do I retrieve values from a database, is it retrieved by using sql statement ?Thank you

Hi all,Please tell me how to use jdbc with MS-excel worksheet. Say I have a file "Emp" in excel and I want to retrieve the data from it. How to do it. It will be of great help if steps and code are given.Thanks

hello I have an application which utilizes a query to take data from a database table & write to an XML file and vice-versa. I have a problem in solving the alias name in queries. e.g Select EmpID as EmployeeID from Employee.. Where EmpID is the original Column name in Table, and when i ...

hi I was working to develop a scheduler .I was able to upload a date into database (MS Access)but i cannot retrieve this date back using a querysample codeString query=new String();query+="SELECT * FROM scheduler_master WHERE sdate=";query+="11/11/2000";ResultSet rs = ...

Hi , If any of you guys tell me to how to pass a variable into an SQL statement....e.g...INSERT INTO TEST Data ( 7, ""+variable , 'Fruday', 2, 2 ) Can anybody clarify whether this is even possible ?

hi allcud anybody please tell how to save an image file in database with any suitable xample or good site/docthkspawan

Hi,I am writing a project using JDBC connecting to the MS SQL database. I am using inet Opta2000 JDBC driver now. I am trying to avoid writing specific driver name or any code related to the specific driver in the code becuase the user of this project may use another type of JDBC driver. Is ...

Is it possible to use a PreparedStatement after its resultset has been processed? It seems to me like once you iterate through the ResultSet the PreparedStatement can not be executed again with a different set of parameters. Is this correct? I'm using the JdbcOdbcDriver, but I am also looking ...

This seems weird, but I really need to do it now. I have a JDBC connection to MS Access. Can I run the Macros or Modules of Access from java codes? By doing this, I am able to avoid starting Access application. Thanks!

I got a ResultSet object from db2 stored procedure called.Here is my code:public static void execute() throws Exception{CallableStatement cs = createConnection().prepareCall("{ call STPR001 (?,?,?,?) }");cs.setString(1, createQueryString());cs.registerOutParameter(2, ...

Greetings,I have cobbled together an app that accesses a DB2 UDB on an AIX box. I am using the IBM driver COM.ibm.db2.jdbc.app.DB2Driver. My app throws a class not found exception and errors out when I try to access the database at exactly the point where the driver loads ...

HiI use the url jdbc:odbc:mydb.mdb to connect to database locally.Now I need to access the machine remotely.The ip of the machine is 192.168.0.7What is the url I need to use to connect to the machine.Thanks

If I'm trying to use the jdbc to upgrade the information on a web page how do i go about it?

I have downloaded it and installed it on my NT box. How do I use this? What's the syntax for making theconnection? Any help is greatly appreciated.

Hi friends,update WebSphere Security fails with my CustomRegistry IBM Interface implementation class using a Oracle8i as registry and datasource.getConnection(). I see a warn: Illegal use of 1PC resource in transaction. Driver for the datasource is a 1PC OracleConnectionPoolDataSource.No fails ...

I am looking for an example for getting a result set back, feed a column of data into a "pull down", select new data and commit.New to java, is there a straight forward example? I have tried to modify the jfc/TableExample2 provided. I am clueless on the approach. I have determined to use a ...