jbuilder 2005 + tomcat 5.0 JBuilderTomcatHibernateOracleSybase

0、数据源的配置
http://localhost:8080/admin声称数据源好像不起什么作用
运行时产生
D:\Documents and Settings\zpt\jbproject\untitled3\Tomcat\conf\server8080.xml文件
手工编辑其，去掉第二行的注释，并加入使其为：

<?xml version="1.0" encoding="UTF-8"?>
	<Server debug="0" port="8081" shutdown="SHUTDOWN">
	  <Service name="Catalina">
	    <Connector acceptCount="10" connectionTimeout="60000" debug="0" maxThreads="75" minSpareThreads="5" port="8080"/>
	    <Engine debug="0" defaultHost="localhost" name="Catalina">
	      <Host appBase="D:\Documents and Settings\zpt\jbproject\untitled3\Tomcat\webapps" autoDeploy="false" debug="0" deployXML="false" name="localhost" unpackWARs="false">
        	<Context workDir="D:\Documents and Settings\zpt\jbproject\untitled3\Tomcat\work\WebModule1" path="/WebModule1" displayName="WebModule1" docBase="D:/Documents and Settings/zpt/jbproject/untitled3/WebModule1" reloadable="true">
	          <Resource type="javax.sql.DataSource" name="jdbc/oracle"/>
        	  <ResourceParams name="jdbc/oracle">
	            <parameter>
        	      <name>maxWait</name>
	              <value>5000</value>
        	    </parameter>
	            <parameter>
        	      <name>maxActive</name>
        	      <value>4</value>
        	    </parameter>
	            <parameter>
        	      <name>password</name>
	              <value>pmiswh</value>
        	    </parameter>
	            <parameter>
        	      <name>url</name>
	              <value>jdbc:oracle:thin:@10.161.160.10:1521:lydyj</value>
        	    </parameter>
	            <parameter>
        	      <name>driverClassName</name>
	              <value>oracle.jdbc.driver.OracleDriver</value>
	            </parameter>
	            <parameter>
        	      <name>maxIdle</name>
	              <value>2</value>
        	    </parameter>
	            <parameter>
        	      <name>username</name>
	              <value>pmis</value>
        	    </parameter>
	          </ResourceParams>
        	</Context>
	      </Host>
	    </Engine>
	  </Service>
	</Server>

1、Hibernate
a、拷贝ojdbc14.jar、jcconn2d.jar到tomcat 5.0\common\lib目录下，
   并添加到jbuilder的JDKS的Class引用中
b、拷贝
cglib-full-2.0.1.jar
commons-collections-2.1.jar
commons-lang-1.0.1.jar
commons-logging-1.0.3.jar
dom4j-1.4.jar
ehcache-0.7.jar
hibern8ide.jar
hibernate2.jar
hibernate-tools.jar
jdom.jar
jta.jar
odmg-3.0.jar
oscache-2.0.jar
   到tomcat 5.0\common\lib目录下，
   并添加到jbuilder的Servlet的Class引用中

package p;

import net.sf.hibernate.*;
import net.sf.hibernate.cfg.*;

public class HibernateUtil {
  private static final SessionFactory sessionFactory;

  static {
    try {
      sessionFactory = new Configuration();.configure(new HibernateUtil();.getClass();.getResource("/hibernate.cfg.xml"););.buildSessionFactory();;
    }
    catch (HibernateException ex); {
      throw new RuntimeException("Exception building SessionFactory: " +
                                 ex.getMessage();, ex);;
    }
  }

  public static final ThreadLocal session = new ThreadLocal();;

  public static Session currentSession(); throws HibernateException {
    Session s = (Session); session.get();;
    // Open a new Session, if this Thread has none yet
    //if (s == null);
    {
      s = sessionFactory.openSession();;
      session.set(s);;
    }
    return s;
  }

  public static void closeSession(); throws HibernateException {
    Session s = (Session); session.get();;
    session.set(null);;
    if (s != null); {
      s.close();;
    }
  }
}


package web;

import p.DB;
import java.sql.ResultSet;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.DriverManager;
import net.sf.hibernate.Session;
import p.HibernateUtil;
import net.sf.hibernate.Query;
import java.util.List;
import hibernates.Cat;
import net.sf.hibernate.LockMode;
import net.sf.hibernate.Transaction;
import oracle.sql.CLOB;
import java.io.Writer;
import net.sf.hibernate.Hibernate;

public class test {
  private String str;
  public String getStr(); {
    return str;
  }

  public void setStr(String str); {
    this.str = str;
  }

  public test(); throws Exception {
    try {
      jbInit();;
    }
    catch (Exception ex); {
      ex.printStackTrace();;
    }
  }

  public void o1(); throws Exception {
    Class.forName("oracle.jdbc.driver.OracleDriver");.getInterfaces();;
    String url = "jdbc:oracle:thin:@10.161.160.10:1521:lydyj";
    Connection conn = DriverManager.getConnection(url, "pmis", "pmiswh");;
    Statement stmt = conn.createStatement();;
    ResultSet rs = stmt.executeQuery("select name from cat");;
    str = "";
    while (rs.next();); {
      str += rs.getString("name");;
    }
    rs.close();;
    stmt.close();;
    conn.close();;
  }

  public void o2(); throws Exception {
    Context iniContext = new InitialContext();;
    Context envContext = (Context); iniContext.lookup("java:comp/env");;
    DataSource ds = (DataSource); envContext.lookup("jdbc/pmis/oracle");;
    Connection conn = ds.getConnection();;
    Statement stmt = conn.createStatement();;
    ResultSet rs = stmt.executeQuery("select name from Cat");;
    str = "";
    while (rs.next();); {
      str += rs.getString("name");;
    }
    rs.close();;
    stmt.close();;
    conn.close();;

  }

  public void o3(); throws Exception{
    Session sess=HibernateUtil.currentSession();;
    Query query=sess.createQuery("from Cat");;
    List list=query.list();;
    str="";
    for(int i=0; i<list.size();; i++);{
      str+=((Cat);list.get(i););.getName();;
    }
    HibernateUtil.closeSession();;
  }

  public void o4(); throws Exception{
    Session sess = HibernateUtil.currentSession();;
    Cat obj=(Cat);sess.get(Cat.class, new Long(2148););;
    obj.setMesString(obj.getMes();.getSubString(1, (int);obj.getMes();.length();););;
    obj.setMesString("成郁落叶沉郁落叶沉鱼落雁沉鱼落雁");;
    Transaction tx = sess.beginTransaction();;

    obj.setMes(Hibernate.createClob(" "););;
    sess.save(obj);;
    sess.flush();;

    sess.refresh(obj, LockMode.UPGRADE);;
    CLOB clob = (CLOB); obj.getMes();;
    Writer pw = clob.getCharacterOutputStream();;
    pw.write(obj.getMesString(););;
    pw.flush();;
    pw.close();;
    sess.flush();;

    tx.commit();;
    HibernateUtil.closeSession();;
  }

  public void s1(); throws Exception {
    Class.forName("com.sybase.jdbc2.jdbc.SybDriver");.getInterfaces();;
    String url = "jdbc:sybase:Tds:10.161.160.10:4100";
    Connection conn = DriverManager.getConnection(url, "pmiswh", "pmiswh");;
    conn.setCatalog("rlzy2");;
    Statement stmt = conn.createStatement();;
    ResultSet rs = stmt.executeQuery("select xm from t_zgxx");;
    str = "";
    while (rs.next();); {
      str += this.native2Unicode(rs.getString("xm"););;
    }
    rs.close();;
    stmt.close();;
    conn.close();;
  }

  public void s2(); throws Exception {
    Context iniContext = new InitialContext();;
    Context envContext = (Context); iniContext.lookup("java:comp/env");;
    DataSource ds = (DataSource); envContext.lookup("jdbc/pmis/sybase");;
    Connection conn = ds.getConnection();;
    conn.setCatalog("rlzy2");;
    Statement stmt = conn.createStatement();;
    ResultSet rs = stmt.executeQuery("select xm from t_zgxx");;
    str = "";
    while (rs.next();); {
      str += this.native2Unicode(rs.getString("xm"););;
    }
    rs.close();;
    stmt.close();;
    conn.close();;

  }

  private void jbInit(); throws Exception {
  }

  public String native2Unicode(String s); {
    if (s == null); {
      return null;
    }

    byte[] buffer = new byte[s.length();];

    for (int i = 0; i < s.length();; i++); {
      buffer[i] = (byte); s.charAt(i);;
    }

    return new String(buffer);;
  }

}

其它参见idea 4.5 使用 tomcat 4