jboss oracle datasource configuration example

Btype); Connection con = null; Statement stmt = null; ResultSet rs = null; try {con = ds.getconnection (); stmt = Con.createstatement (); rs = Stmt.executequery ("Select Empid, name from Employee"); while (Rs.next ()) {System.out.println ("Employee id=" +rs.getint ("Empid") + ", name=" +rs.getstring ("Name")); }} catch (SQLException e) {e.printstacktrace (); }finally{try {if (rs! = null) rs.close ();

location: under the%jboss_eap_home%/modules directory To configure a resource as a JBoss module: writing the Module.xml file Next, take Oracle as an example to build an Oracle driver module1. Create directory%jboss_eap_home%/modules/com/oracle/main/, store

Tags: des blog http io ar os java for SPhttp://blog.csdn.net/bo_hai/article/details/6076979Configuration template for Oracle-ds.xml in JBOSS. Code templates: Here is a couple of the possible OCI configurations.For more information, see http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/toc.htmOrClearly, its better to has TNS set up properly.--- PS (Postscript): Above

Oracle boot, add ABC instance self-starter switch# Vi/etc/oratabOrcl:/u01/app/oracle/product/10.2.0/db_1:yAbc:/u01/app/oracle/product/10.2.0/db_1:y(2) Set boot start# vi/etc/rc.local#!/bin/shSu-oracle-c "Lsnrctl Start"Su-oracle-c "Dbstart"(3) Logging on to the database serv

In some cases, for example, you need to configure static registration for the listener. ora of the standby database when performing the upload uard operation. In some cases, for example, the listener. ora of the standby database needs to be configured for static registration when data guard is used. In some cases, for example, the listener. ora of the standb

Oracle: listener. ora, sqlnet. ora, tnsnames. ora configuration and example1. Solve the problem: TNS or the database cannot log on.The simplest and most effective method: use the tool netca provided by the Oracle System to configure (delete the original one and reconfigure it)$ Netca 2. However, I still have questions: how do I specify the directory where 'listen

When you configure ADG or use the HA for cluster management applications of Oracle (such as OGG), we may want to use a different network to avoid the impact of ADG transmission logs on the primary production network.Starting with 11.2, we can use CRS to manage multiple network resources (the default is NETWORK1 only), but scan can only be active on one of multiple networks (the default is NETWORK1, which can be assigned to different networks).Then, we

7. Install ORACLE Database ORACLE9I with three disks ABC. After mounting disk A | disk B, you must manually select disk B | disk C. During the installation process, select the default value. You must manually 7. Install the ORACLE database ORACLE 9I with three disks A \ B \ C. After mounting disk A | disk B, you must manually select disk B | disk C. During the in

1. Select WINDOW> display View> other. The following window is displayed: The content in this window is as follows (the following content is critical ): Currently, ORACLE9I is installed in the default directory. Therefore, the JDBC driver of ORACLE9I is in C: \ oracle \ ora92 \ jdbc \ lib \ ojdbc14.jar, copy the file to the current jdk lib, So copy the file to C: \ Program Files \ Java \ jdk1.5.0 _ 04 \ lib. In the Connection URL: loc