//
archives

JDBC

This category contains 7 posts

Test JDBC Thin connection to Oracle RAC database (11gR2)

Test JDBC Thin connection to Oracle RAC database (11gR2) Set the classpath Oracle Client configuration testdb= (DESCRIPTION= (FAILOVER=ON)(LOAD_BALANCE=ON) (ADDRESS= (PROTOCOL=TCP) (HOST=testdb-cluster-scan.newzonetech.com) (PORT=1521) ) (CONNECT_DATA= (SERVER=dedicated) (SERVICE_NAME=testdboltp.newzonetech.com) ) ) testdb1= (DESCRIPTION= (FAILOVER=ON)(LOAD_BALANCE=ON) (ADDRESS= (PROTOCOL=TCP) (HOST=testdbt01.newzonetech.com) (PORT=1521) ) (CONNECT_DATA= (SERVER=dedicated) (SID=testdb1) ) ) Database Configuration JDBC Thin connection methods For single instance Oracle database, the connection string … Continue reading

JDBC Code with Oracle – Transaction

JDBC Code with Oracle – Delete

JDBC Code with Oracle – update

JDBC Code with Oracle – Insert

 

JDBC Code with Oracle – select

1) Install Oracle Database Client 2) set classpath 3) Java code for SelectTest03.java

JDBC Connections

1.Access 2.MySQL (http://www.mysql.com) mm.mysql-4.0.2-bin.jar or: 3.Microsoft SQLServer (http://jtds.sourceforge.net) 4. Microsoft SQLServer (http://www.microsoft.com) 5.oracle (http://www.oracle.com/ip/deploy/database/oracle10g/) classes14.zip 6.Sybase (http://jtds.sourceforge.net) jconn2.jar 7.ODBC 8.DB2 9.PostgreSQL (http://www.de.postgresql.org) pgjdbc2.jar