hi,does anyone know how to use the deploytool come with the j2ee sdk to add a ConnectionPooledDataSource(eg. OracleConnectionPooledDataSource), which later on i can using JNDI lookup the ConnectionPooledDataSource from my program(code). This is very urgent to me and i had been searching and ...

Hi, I am Sys Prog i wanted to know to compile a jdbc with db2 on the mainframes

Hi all.I have db in a remote sql server.I want to update the data base from my own computer using gui. I need to make simple actions like:add a new record, remove a record, update a record. nothing sophisticated like adding a new table or removing a table.So anyone know where can I find ...

Yes, I am a newbie to JTA/JTS, but not to Java and many of the API's therein.What I have is one User JavaBean (not EJB). When I file the user, I am filing the User to the User table AND a Join table in the database.Obviously, I want to make sure that this is controlled in a transaction to make ...

Hey everyone,I know that this topic has been discussed before, and I HAVE read all of the threads, but I still can't insert text into a memo field.I have used prepstmt.setString(...), prepstmt.setAsciiStream(...), prepstmt.setCharacterStream(...) and I keep getting the "Function sequence ...

Hi all,when we delete the record from the table, size of the file is not reduced. but when add the record to the table, the size is increasing. Can anyone suggest why size of the file is not reducing when delete record from the table. Best Regards,Muthu.

HEEEEEEEEELP!!!! Hi everyone, i need urgent help about getting multiple resultsets from a stored procedure. i have JavaWebServer2.0 and MSSQL Server 2000 running on Windows2000. in my servlet i connect to the database, call a stored procedure and get the two resulsets the procedure returns. i ...

I'm having a problem with the addRequirement method in the following class. When I try to run the calling class (TraceTool), I receive the following run time message - Exception in thread "main" java.lang.NullPointerExceptionat RequirementDatabase.addRequirement(RequirementDatabase.java:36)at ...

Hi,Can anyone please let me know what's the jdbc URL for local database on Oracel personal edition 8.0.4?I have installed Oracle personal edition 8.0.5 on a win 98 machine. When I tried to write a java prg. to connect to that using jdbc thin driver for 8.0.5.2 for local database, it failed to ...

Hello,I am having a problem with my database driver. The thing is that the class is compiling correctly, but only when I execute the createPool() function from one of my JSP's, do I get the following 500 Servlet Exception (the ConnectionPool class follows the ...

how to insert a simple timer to this code ?void jButton4_actionPerformed(ActionEvent e) {jLabel1.setText("Loading ..");// insert timer here setGetShow("A","t4d"," ","1");jLabel1.setText("Done.");}

Hello,When I have added ResultSet statements in the programme, the programme is giving me exceptions at run time as java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2. at java.lang.Throwable.<init>(Compiled Code) at ...

Is there free driver for use?anyone can tell me ?thank you lqh_98@hotmail.com

I installed the Postgresql(version 6.5) under Redhat Linux 6.1;In the System Jdk1.2.2 are also installed. When I run a java program with a connection to a database, I receive the error msg:"Java.sqlException: not suitable driver"; I think it means that jdbc driver is not correctly installed; I ...

I installed the Postgresql(version 6.5) under Redhat Linux 6.1;In the System Jdk1.2.2 are also installed. When I run a java program with a connection to a database, I receive the error msg:"Java.sqlException: not suitable driver"; I think it means that jdbc driver is not correctly installed; I ...

Hello We got some strange behavor when we trying to dynamicaly create tables in Oracle 8.1.6 trought JDBC.before creating new table I check that table already exists and in this case drop existing one.after that I create table with name similiar to dropped table.Ooops - table still exist. ...

I have installed J2EE SDK 1.3 beta 2, and was going along well until I reached the Dukes Bank sample application.I have gone through step by step as stated in the tutorial, using ant to compile everything. I use the deploytool to open the resulting DukesBankApp.ear file and everything looks ...

Is there any report designing tool, avaible for java applications? e-g Seagate Crystal reports can be view through java code?I want to design a database systemin java but main problem facing is no compatible report tool found.

I try to connect to Oracle database using JDBC classes12, javasdk 1.3.1. Under netscape i connect with this command String connect_string = "jdbc:oracle:thin:r4/r4(description=(address_list=(address=(protocol=tcp)(host=myhost)(port=1521)))(connect_data=(sid=mysid)))";try ...

Hi I want to make a utility which works at the time of deployment making all the connection entries in windows DSN at the install time and keep on adding dsn from the program as & when requiredThanks Ajay Karkara

Hi...I am not very experienced with Java and databases and I need an advice for the following problem:I wrote an applet (game) that saves the player's score and other stuff in a mySQL database.The applet directly connects to mySQL, so the applet needs to know the login/password for the ...

I want to know whether we can connect to a MS Access database without a jdbc odbc driver?thanxshrinivas

Hello,I am trying to connect the database(orcale 7) which is in the remote machine using Microsoft JDBC driver. But the following errors are thrown. If any one know how to solve this, pl let me throw some lite on this.Errir message as/./.......................java.sql.SQLException: ...

Hi,well there is a list of tour guides i have who can be provisionally allocated, not allocated or allocated to tours. the dates on which they are allocated is going to be stored in the database. this data is to be retrieved from the database and then graphically represented on a JSP page. what ...

hi i am unable to close the connections left unclosed after the JSP application is terminated abruptly, iam using connection pooling in which the maximum number of connections are set. i am unable to run the application further unless the connections lying in the database are closed.is there ...

I am using Oracle 8.0 as my Database and java 1.1.7 Application as a client(JDBC 1.1).i am facing shared pool memeory problem.i have set shared pool memeory as 20 MB in init.ora and i dont want to increase it.To obviate this problem , instead of using Statement , i am using Prepared Statement ...

I am using Oracle 8.0 as my Database and java 1.1.7 Application as a client(JDBC 1.1).i am facing shared pool memeory problem.i have set shared pool memeory as 20 MB in init.ora and i dont want to increase it.To obviate this problem , instead of using Statement , i am using Prepared Statement ...

I have created signed applet which work well but when i try to connect to database which is different than from which the applet come, i get this error. java.security.AccessControlException: access denied (java.net.SocketPermission my.database.host.com resolve)Are there any other things which i ...

Greetings,I am attempting to connect to a DB2 UDB (6.1) on an AIX (4.x) box from a win95 box and have cobbled some code together to do this. Despite loading and verifying that the driver loads, I get nothing but the SQLException: "No Suitable Driver". My Java code follows for comment. Thanks in ...

Hello,I'm using the oracle drivers found in classes111_01.zip for oracle 8 and jdk1.3. Everytime I try to 'executeUpdate()' I get an error. The error is:java.sql.SQLException: ORA-00928: missing SELECT keywordHowever I am using 'excuteUpdate()' not 'executeQuery()' or 'execute()'. Why ...

Hi all!i'm trying to connect to a ms sql server database but i've got always the same error:"SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor state"Why?Can anybody help me?Thanks in advanceCode:Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();Connection ab7Con = ...

I'm re-evaluating my companies choice of a DBMS, and quite frankly I'm pretty overwhelmed with the choices available. Here's what we're trying to accomplish:1) Writing a pure Java standalone application (although the database doesn't necessarily have to be written in Java).2) Platform ...

Hai,I have to display 10 records in each page with previous,next button for navigation.Now I have an index for each page.Each time the user clicks on previous (or) next button I'll calling the same JSP file which will produce a resultset each time.So each time I connect to database.When I was ...

initially table looks like this: Primary keyResource idstatusStart dateend date Now we start allocating resources to say tours as a tour guide.so we say:Resource idstatusStart dateend date1000confirmed 5thSep 8th Sep1000provisional9thSep14th Sep1000confirmed 20thSep25th SepNow the above data is ...

Hi,I have a Javabean which has a "java.sql.Connection" member variable called "connection". This variable is populated in the constructor event, after connecting to the database. In the finalize method, I try to close the connection to release the database resource when the bean goes out of ...

I'm trying to pass in the nextVal of a sequence to an argument of the Callable Statement, but am unable to find any references. Any tips? Cheers!

HiI am using MS SQL servcer from java through JCBC-ODBC bridge. After establishing connection I can create a statement which is working just fine but I want to gather data from another statement from the loop of first connection, for example..// loop of 1st ...

Hello all,Can somebody tell me how to integrate cookies in servlets ?I would like to put a password in cookies and use it in all my java servlets files.Please help.

Hi,here is my problem.i have the same tables in MSaccess and oracle.the program works fine with access. but, with oracle i am gettingjava.sql.exception:Invalid colum number<1>thanks

Hello All:I got a problem with executing my store procedure can anybody help?STORE PROC CREATE PROCEDURE dbo.skill_cat(@cat_desc char(40), @subcat_desc char(40),@skill_desc char(40))ASdeclare @cat_id int, @subcat_id int, @skill_id intBEGIN--Process Categorybegin tran catif not exists (select ...

I recently write a program using JDBC 2.x batch updation feature and the code as shown as below:Statement stmt = con.createPreparedStatement(sql);stmt.setObject(1, "testing 1");stmt.addBatch();stmt.setObject(1, "testing 2");stmt.addBatch();stmt.executeBatch();An ArrayIndexOutOfBounds Exception ...

I get the following after successful connection to an AIX DB2 UDB from my win95 workstation:COM.ibm.db2.jdbc.net.DB2Driver@2e000dCOM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0601E Invalid statement handle or statement is closed. SQLSTATE=S1000The code causing it is creation of a ...

I would like to insert the same row immediately after it's deletion (making changes on non-primary fields). It looks like it is giving some problems some times that I could not trace it out!! Using sql server database.Plz help me.thanksshiva.

Hi. I have a problem.I have a ResultSet object as input. I need to do a further query on this ResultSet object. How do I do that? I cannot find any suitable method on the JDBC API. Can someone help plz? Its very urgent !!!Thank you very much.Regards,arul ...

In the javadoc, Statement.close() says: Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.Connection.close() says: Releases this Connection object's database and JDBC resources immediately instead of ...

Hi,I'm trying to call an Oracle stored procedure with one of the parameters being a Clob.First I select a clob from a temporary table, manipulate it and then call the stored procedure.I always get the error "java.sql.SQLException: ORA-22990: LOB locators cannot span transactions"Until then ...

i have problem in setting up poolman correctly while put the poolman.jar, jdbc2_0-stdext.jar, jta.jar,xerces.jar on web-inf/lib and poolman.xml;but it seemly can't work fine!what step do i miss?thanks in advice,

Does anyone know of a type 2 JDBC driver for MS SQL Server?

I meet the excepiton like below:java.rmi.ServerException: Could not obtain JDBC Connection from datasource: DataSource2; nested exception is: java.sql.SQLException: ITS-7004: Two-phase txns not allowed with JDBCjava.sql.SQLException: ITS-7004: Two-phase txns not allowed with JDBCi don't konw ...

The following two lines result in the variable columnValue being set to null:Object columnValue;columnValue = rs.getObject("columnName");whereas when replaced with the following two lines columnValue is set to the correct string value:Object cloumnValue;columnValue = ...