Oracle Driver
hi!!
I need to use a jdbc connection to a Oracle database.
I have done in the IDE with de datasource the connection, but now I want to do with stored procedures in jdbc writting my own code. Here it is the variables of the stored procedure.
cs.registerOutParameter(1, Types.OTHER);
cs.setObject(1, rs);
cs.setInt(2, p_oficina);
cs.setInt(3, p_producto);
cs.setInt(4, p_cuenta);
cs.setDate(5, p_fdesde);
cs.setDate(6, p_fhasta);
cs.setInt(7, p_gestor);
I read that I have to put cs.registerOutParameter(1, OracleTypes.CURSOR);
, but I can't find oracle.jdbc.driver.* to import.
Do you know where i can find o how I can do?
Thanks!!!
# 1
Hi again!!
I download the oracle drivers from the oracle page. The drivers are into the classes12.zip file. I make a .jar file and try to add to the project but the ide says me that he don't find the source archive of the .class files. I also try adding .zip file but he says me the same problem.
How can I add a .jar or .zip files in the Studio Creator?
# 2
the following driveres have been registered for the creator,* Oracle (8iR3, 9iR2, and 10gR1)* Microsoft SQL Server 2000 SP3* Sybase ASE 12.5* IBM DB2 V8.1
# 3
To add a new driver to Java Studio Creator, follow the steps in:
http://developers.sun.com/prodtech/javatools/jscreator/learning/tutorials/2/dbs erversources.html
Briefly:
Data Sources -> Edit Database Server Types -> New
Select jar file, and fill in the rest of the information.
Then, Data Sources -> Add Data Source
Select the Server Type you just created, and fill in the rest of the information.
Note that this won't add the driver to the project; you will still need to take steps at deployment time to ensure that the drivers are installed on the target platform.
Also, the Oracle drivers have some known problems (JDBC 3.0 methods that are not implemented correctly). The DataDirect drivers are bundled with Jave Studio Creator, for development work.
-Jim
Java Studio Creator Team
# 4
Hi escritorioooo ,did you make it work? If yes, would you mind sharing your code here? I've got the same problem as you did, and I need the solution right now.thanks in advance
