Hi,I have a jdbc connection over a bea jdbc-driverto a MS Sql-Server. If I run my applet in the applet-viewer fromsun, I got the connection.But if I run the same applet from Internet Explorer 5.5, with java plug-in, I got a security exception.I'm working on one machine.Who knows what the ...

How do I do this:select * from table where column like "text%"and I want it to match either "TEXT..." or "text..."thanks to anyone who can answer this or point me to a definitive SQL document that contains this information...

Subject: PERFORMANCE while accessing remote databaseWe have IBMWebSphere Application Server Standard Edition 3.5.3 running on AS/400 iSeries Server (V4R5, test)and local DB2 Database. I am using AS/400 Developer Kit for Java JDBC Driver(type2, com.ibm.db2.jdbc.app.DB2Driver)to talk to local ...

Hi folks,When I try and re-use my connection to the database I receive the following:java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmtIs there something that I need to reset in my ResultSet object before creating another statement? ...

I have postgresql working with tomcat on Red Hat Linux 7.0. I can query a sample database with a standard java program (one with main). However, when I put basically the same code in a servlet, I get an error message that it can't find the postgresql driver. I am able to run servlets without ...

private static void myRun (Connection oConnection,Integer oId)throws Exception{PreparedStatement oStatement = null;ResultSet oResultSet = null;try{ oStatement = oConnection.prepareStatement ("select dii_import.* from dii_import where dii_history_oid = ? " +"and dii_import_status = ...

Can anyone tell me where to find a sql Jtable examplereally simple one.Pls mat21

hi everyone, I have a urgent project that runs on IBM AIX, and I must using JDBC connecting to Oracle 8i DB Server. I connect to Oracle website(OTN), I just find the JDBC Driver for Windows and Solaris platform. so some body help me , and tell me how to get the proper jdbc driver for AIX ?! any ...

why cann't Tomcat4 find MySQL driver which I put in WEB-INF\classes directory? my bean words fine as a standalone application(CLASSPATH setting is fine), but when I try to use it in my JSP page, Tomcat just cann't find the Driver class, even thought I put org.git.mm.mysql directory structure ...

Hello,I use a Centura DatabaseI want to read a file and then insert some data from each line into a database. The file I read has at least 640 lines. Everything works for 81 lines readed but then, I receive the following error message :" SQLExceptionjava.sql.SQLException: ...

Do anyone of u ever meet sure a error?Javax(X) This program has performed an illegal operationand will be shut downIf the problem persists,contact the program vendorDetailsJAVAW caused an invalid page fault inmodule <unknown> at 0096:1f43b3f0.Registers:EAX=05c706b4 CS=0167 EIP=1f43b3f0 ...

Normally i do a SQL query using JSP to the database with a JDBC:ODBC bridging, but later i found out that my webserver doesn't support this feature(JDBC:ODBC) and i am thinking of converting my database to a txt file. Then will i be able to sql a text file. Or is there any better advise from ...

with ResultSet rs, I write the following lines...rs.updateString("Title", newTitle);rs.updateRow();I find the underlying database table (MS Access 95) updates fine, but the ResultSet row itself doesn't!... I then have to call rs.refresh()... but I was wondering whether there's some way I can ...

I am trying to make a JDBC connection between a weblogic-Java server and an Oracle server. Unfortunateley there is a firewall between them. The connection request is through port 1521 and the firewall lets the request go through. The problem is that the response from the Oracle server uses a ...

Hi, I can't seem to get a connection to the server and I don't know why. I can access the database from the command line. With the same code installed at work, everything works fine. i'm running windows 2000 using mm mysql driver with the client and server running on the same machine. ERROR ...

Situation: I am working with JDBC 2.0, jdk 1.2. I do not have access to the oracle.sql.ClobProblem: I can get the Clob out of the data base, using a select...for update, resultSet.getClob(). But I can find no way to update the Clob before saving it. Every comment on this topic that I can locate ...

I have written a JSP page that makes a connection to an Oracle 8i database using the following code://Load the jdbc drivertry{//Retrieve stored connection string parameters from session objectString sysDSN=(String)session.getValue("sysDSN");String ...

Dear reader,Below is the problem I'm runing into.An error message "Invalid Handle" was coming out when I try to insert a record into SQL Server.Below is the corresponding.query = "insert into artworkstudent_lk (artwork_id, student_id) values ...

I am preparing a simple process that opens an oracle database and returns a resultset. However, I am getting an error on this line:cnConn = new DriverManager().getConnection( "jdbc:oracle:oci8:@dahl", "test", "test" );I receive the following error message:TestODBC.java:56: DriverManager() has ...

dear readers,I am doing a project where i have to write a class code for connecting to the data source without any manually configuration to the data source for the Access database in the Control Panel-ODBC Data Source.Is there any way that i could do that?

hi,i am doing a project that basically programmatically create a data source connection using ODBC. Is that any way that i could do that?

I am using Tomcat 4.0 and I have set up a datasource to talk to my Oracle 8i database. It connects just fine but it immediatly errors out with a maximum number of processes error. I bumped it up from 59 to 100 in the init.ora file and it still bombs out. How can I limit the number of ...

Hello, I have a problem with DB2 Date data types and the DB2 JDBC driver. I have been using rset.getDate() and a column of this type but now suddenly when it was changed from ISO to standard DB2 type or the other way around, it stopped working and started giving wrong dates (something like year ...

i would like to know if i could use the program code below to connect to the odbc data source automatically.I got an error code saying that***********************javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or ...

Hi to all,Can body assisst me as how to check the table in my database.I am proceeding to create table throught my application its creating perfectly but i want to check whether it exist already, if exist it should proceed with inserting records in it.Thanks in advance.khiz_eng ...

hello,do anyone know how to add tableheader, easy one.

Hi everyone !My Problem is as following:1. I've got a generic Database (over JDBC-ODBC)2. I'v got an application with a JTree3. I want to get the relations between tables4. Those relations should be put in a hierarchical tree (namely JTree) to get a complete map of the Database!I know, i have ...

Hi,[sorry -- posted this in 'signed applet' by accident]As many others, I want to connect from an applet thru the intranet to our Oracle8i-db. I read lots of articles about e.g. applet-security. I did not make any changes in java.policy! Two questions, thanks for any help on ANY of the ...

I am using JSP 1.0 as the frontend and MySQL 3.23.24 as the backend under Windows 98 and Java Web Server 2.0. I am trying 2 connect 2 the database via a Java Bean, and by using a DSNless connection and a JDBC-ODBC Bridge. The JWS gives me problems when I try running the bean through my JSP ...

we are working on jsp based application which execute stored procedure inside sqlserver7.0. we are using FreeTDS driver for database connectivity. it works with sql queries very well. but FreeTDS diver is giving exception while executing stored procedure. it is displaying following error... ...

I would to program a class that connect to data source without any manually configure.Is there other way that i could use intsead of usingdb = DriverManager.getConnection("jdbc:odbc:Driver={SQL Server};Server=MyServerName;Database=MyDataBase","","");My project requires me to use JDBC-ODBC ...

Hi to everyone,Can anybody assisst me in connecting to MS-Access database without configuring manually in control panel.I want my application should confugure programatically.Thanks in advance.Regardskhiz_eng

Hi,we are using Oracle8i database and we were told to use Oracle JDBC OCI Driver 8.1.7. (Client-side JDBC for use on a machine where OCI 8.1.7 is installed)I suppose this is a driver that belongs to Category 2 = A native-API partly Java technology-enabled driver .So, i assume if we use this ...

I do not want to make dsn through windows/start/settings/control panel/odbc datasource. I want that my application should make the dsn through java program. The dsn will be used by jdbc-odbc bridge to make the database and create and manipulate the tables. Every thing through code only. I am ...

Just moving over from asp to jsp, (very new)In asp I would put ("INSERT INTO Message (MessageSubject, MessageBody) VALUES ('"&MessageSubject&"' , '"&MessageBody&"' ) "); How are the values entered in jsp?

Does anyone know, whether oracle8i supports updatable resultset.I tried creating one but i get read only resultset.The code i used was:PreparedStatement ps = conn.prepareStatement("Select * from tbl",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);i am using OCI driver and ...

Hi,I write a program to query data from MS SQL Server 7.0. The problem is the amount of data I query is very large, about 1.5 million rows. When I fetch about 90,000 rows , there is a exception just as below.java.lang.OutOfMemoryError<<no stack trace available>>Exception occurred ...

Hello,I have several date-time fields that I would like to store in a database in GMT. These times will be viewed and entered from different TimeZones. The problem is I can't figure out the interaction between the database and JDBC, and what is the TimeZone of the time that is actually being ...

Hi,I have situation where in I need to create dynamic sql statements based on user input.let's say user changes his last name or only first name or some comments field only those fileds changed should be updated in database leaving rest un changed. I am using PreparedStatement to update (this ...

Hello,I have a few pages that need to close a DB connection. But if no DB connection exists, then I am getting an "Undefined Variable or Class" error. I have an object "conn" instantiated from the Connection class. Is there any way to see if "conn" exists before I try to close it?Thank ...

hi,We need to provide a service for a partner. Which performances better-- direct JDBC from partner's application server to our database, or we host SOAP service and implement soap client call in partner's application server? Also, can JDBC go through firewall?Thanks,Dean ...

Is there any uniform way to retrieve the SQL executed by the JDBC driver when executeQuery or executeUpdate is called on PreparedStatement? For troubleshooting SQLException's thrown from executeXXX, it would be helpful to be able to see what the resulting SQL statement is after setting all the ...

Can any one tell me how the setArray is used in PreparedStatement where in the Query takes 2 parameters. Now the requirement is that instead of me running the SQL in loop for different values, I just want to set the array using setArray method of PreparedStatement.Snippet of code will be of a ...

Hello All,I am using Oracle Database. In my tables I have many fields which are auto-numbered by the use of oracle sequences.Is there any way, I can find out which field of a table uses which sequence?Does JDBC allow me to fetch this kind of meta data?I checked out the class DataBaseMetaData ...

I'm looking for a driver for a flat file.I want to read the file as if it is a database.Does anybody know where i can find this?cheers Wouter

what is the difference between file dsn and system dsn

Hello friends,I'm writing some database access code in java. The biggest problem I face is date fields. Because I don't know the date field format (For example, in SQL Sever we can have dd/mm/yy or mm/dd/yy, etc), I can't format dates for insert/update statements.Is there a way to determine ...

Hi,I am writing code on JDBC to MS SQL Server. I need to test if the connection is closed. But I didn't find any method to reopen the connection. Does anybody know what I should write if the connection is closed:if (conn.isClosed()){//I want to reopen the connection}Thanks! ...

Hello Friends,Can Statement object support multiple ResultSets simultaneously?For example:Set rs = stm.executeQuery(sql);while (rs.next()) { Set rs2 = stm.executeQuery(sql); while (rs2.next()) { } rs2.close();}When I execute this kind of code the rs is being closed. Does it mean that Statement ...

Hi,I am using JDBC-ODBC drivers to talk to the database. Everyhting works just fine like I can talk to the database, get the records and process.However my question is, when will the database connection OPENED in the program be closed. Say, if I didn't use connection.close() in my class, will ...