一个使用weblogic的问题
package testweblogic;
import java.sql.*;
import java.util.*;
import javax.sql.*;
import javax.naming.*;
import javax.transaction.*;
import javax.transaction.xa.*;
public class test {
public test() {
}
public static void main(String[] args) {
Hashtable ht = new Hashtable();
ht.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory");
ht.put(Context.PROVIDER_URL,"t3://localhost:7001");
Connection con = null;
try{
//连接的一个access的jdbc-odbc数据库
Context ctx = new InitialContext(ht);
//UserTransaction tx = (UserTransaction)ctx.lookup("javax.transaction.UserTranscation");
//tx.begin();
//查找weblogic中建的数据源
DataSource ds = (DataSource)ctx.lookup("lijun1");
con = ds.getConnection("lijun","33333333");
DatabaseMetaData dbmd = con.getMetaData();//获取数据库信息
String drivername = dbmd.getUserName();
System.out.println(drivername);
Statement st = con.createStatement();
ResultSet res = st.executeQuery("select * from chengji");
//Hashtable ht1 = new Hashtable();
//ht1.put("1",res);
//ResultSet a = (ResultSet)ht1.get("1");
String line = "";
while (res.next())
{
line = line + res.getString(2)+"\n";
}
//line = line + a.getString(2)+"\n";
System.out.println(line);
PreparedStatement p = con.prepareStatement("insert into chengji(name,sex) values(?,?)");
p.setString(1,"z");
p.setString(2,"zzzzzzzzzzzzzzzzzzzzz");
p.addBatch();
p.setString(1,"wwwwwwwwwwwwwwwwwwwww");
p.setString(2,"wwwwwwwwwwwwwwwwwwwww");
p.addBatch();
p.executeBatch();
//tx.commit();
//con.close();
}catch (Exception ex)
{
System.out.println("fail");
/* if(con!=null){
try{
System.out.println("rollback");
con.rollback();
}catch(Exception e){
}
}
*/
}
}
}
这段程序的数据源在weblogic中应该如何设置呢?
问题点数：0、回复次数：2Top
1 楼zez（思恩 闭关练功ing...）回复于 2003-06-03 09:06:03 得分 0
在你的weblogic控制台设置连接池和数据源
jnid名字叫 lijun1
你的程序就可以运行了...Top
2 楼zez（思恩 闭关练功ing...）回复于 2003-06-03 09:07:41 得分 0
JDBC-Conncetion pool -> config new ... ->
Name: samplePool
URL: jdbc:weblogic:mssqlserver4:127.0.0.1:1433
Driver Classname: weblogic.jdbc.mssqlserver4.Driver
Properties (key=value):
db=sample
user=sa
password=
apply -> target -> chosen (myserver) -> apply
Tx Data Source -> config new..... ->
Name: 名字,随便起
JNDI Name: 你的jndi名字 只要这里是你自己的就行了
Pool Name: 上面配置的pool的名字,必须[保证和上面一样!!!
同上,apply -> target -> chosen -> apply !!
ok.complete!!!
Top
