关于weblogic9.2中的mysql数据源

xiaocong000 2008-03-25 11:32:47

我在weblogic9.2中已经配置好数据源了，weblogic也显示我的创建成功，可就是连不上，不知道怎么回事，希望各位前辈指点一下，小弟初学，谢谢

下面的是我的代码：
import java.sql.*;
import javax.naming.*;
import javax.sql.DataSource;

import java.util.*;

public class mysqltest {

public mysqltest()
{
}

public static void main(String[] args) {
// TODO Auto-generated method stub
DataSource ds = null;
Context ctx = null;
Connection conn = null;

try
{
//获得WegLogic Server JNDI属性初始上下文信息
Properties properties = new Properties();
properties.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory");
properties.put(Context.PROVIDER_URL,"t3://localhost:7001");
ctx = new InitialContext(properties);

try
{
ds = (DataSource)ctx.lookup("mysql");
}
catch(ClassCastException d)
{
d.printStackTrace();
}
if(null != ds )
System.out.println("obj:"+ds.toString());
else
System.out.println("it is null");
}
catch(Exception e)
{
System.out.println("Init error is : "+e);
}

Statement st = null;
ResultSet rs = null;

try
{
conn = ds.getConnection();
st = conn.createStatement();
String sql = " select * from stu;";
rs = st.executeQuery(sql);
int i = 0;
while(rs.next())
System.out.print(i+" || name :"+rs.getString("name")+" age :"+rs.getInt("age"));
rs.close();
}
catch(SQLException e)
{
System.out.println("Error code is :"+e.getErrorCode());
System.out.println("Error message is :"+e.getMessage());
}
finally
{
try
{
if(null != st)
st.close();
if(null != conn)
conn.close();
}
catch(SQLException e)
{
System.out.println("Error code is :"+e.getErrorCode());
System.out.println("Error message is :"+e.getMessage());
}
}
}

}
下面的是运行时的出错信息：
obj:IOR:0000000000000044524d493a7765626c6f6769632e6a6462632e636f6d6d6f6e2e696e7465726e616c2e52656d6f746544617461536f757263653a30303030303030303030303030303030000000000100000000000003b0000102000000000a3132372e302e302e31001b590000008800424541080103000000000c41646d696e536572766572000000000000000044524d493a7765626c6f6769632e6a6462632e636f6d6d6f6e2e696e7465726e616c2e52656d6f746544617461536f757263653a30303030303030303030303030303030000000000432383600000000014245412900000010000000000000000082af352dda56700400000006000000010000002c000000000001002000000003000100200001000105010001000101000000000300010100000101090501000100000019000000380000000000000030687474703a2f2f3132372e302e302e313a373030312f6265615f776c735f696e7465726e616c2f636c61737365732f000000001f000000040000000300000020000000040000000100000021000000580001000000000001000000000000002200000000004000000000000806066781020101010000001f0401000806066781020101010000000f7765626c6f67696344454641554c5400000000000000000000000000000000004245410300000218000000000000000c726f756e642d726f62696e0000000000000000066d7973716c0000000000000100000044524d493a7765626c6f6769632e6a6462632e636f6d6d6f6e2e696e7465726e616c2e52656d6f746544617461536f757263653a3030303030303030303030303030303000000000010000000000000190000102000000000a3132372e302e302e31001b590000008800424541080103000000000c41646d696e536572766572000000000000000044524d493a7765626c6f6769632e6a6462632e636f6d6d6f6e2e696e7465726e616c2e52656d6f746544617461536f757263653a30303030303030303030303030303030000000000432383600000000014245412900000010000000000000000082af352dda56700400000005000000010000002c000000000001002000000003000100200001000105010001000101000000000300010100000101090501000100000019000000380000000000000030687474703a2f2f3132372e302e302e313a373030312f6265615f776c735f696e7465726e616c2f636c61737365732f000000001f000000040000000300000020000000040000000100000021000000580001000000000001000000000000002200000000004000000000000806066781020101010000001f0401000806066781020101010000000f7765626c6f67696344454641554c54000000000000000000000000000000000000000000ffffffffda567004Exception in thread "main" java.lang.ClassCastException: weblogic.jdbc.common.internal.ConnectionEnv
at weblogic.iiop.IIOPOutputStream.writeObject(IIOPOutputStream.java:2209)
at weblogic.utils.io.ObjectStreamClass.writeFields(ObjectStreamClass.java:396)
at weblogic.corba.utils.ValueHandlerImpl.writeValueData(ValueHandlerImpl.java:235)
at weblogic.corba.utils.ValueHandlerImpl.writeValueData(ValueHandlerImpl.java:225)
at weblogic.corba.utils.ValueHandlerImpl.writeValue(ValueHandlerImpl.java:182)
at weblogic.iiop.IIOPOutputStream.write_value(IIOPOutputStream.java:1913)
at weblogic.iiop.IIOPOutputStream.write_value(IIOPOutputStream.java:1948)
at weblogic.iiop.IIOPOutputStream.writeObject(IIOPOutputStream.java:2209)
at weblogic.jdbc.common.internal.RmiDataSource_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:517)

at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:224)
at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:407)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:403)
at weblogic.rmi.internal.BasicServerRef.access$300(BasicServerRef.java:56)
at weblogic.rmi.internal.BasicServerRef$BasicExecuteRequest.run(BasicServerRef.java:934)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:181)

...全文