又是插到缺省的hsqldb里了,唉

解决方案 »

  1.   

    create函数重写了吗,主键id是不是自增字段啊
      

  2.   

    连接对,我用的是oracle数据库,数据源配置和我用sqlplus连接oracle的用户密码一样,表名也一样,我检查很多编了!!另外:eyeieye(魔之眼) ( ) 
    不知老兄您说的是啥意思呀,能说清楚一些么,先谢谢啦!!!
      

  3.   

    jb9下怎么集成jboss?楼主拜托了:)
      

  4.   

    你改了jboss那些什么jdbc.xml文件了没?它们都是把cmp什么的绑定到hsqldb,还会自动建表,嘿嘿。
      

  5.   

    谢谢 eyeieye(魔之眼),我看看,好用后给分!!!
      

  6.   

    在JBOSS3.X下配置Oracle数据库一、 安装数据库驱动
      将oracle的jdbc驱动classes12.zip拷贝至Jboss_HOME/server/default/lib目录下,并将zip后缀改为jar。
    二、 安装数据库描述文件
      将Jboss_HOME/examples/jca/oracle-ds.xml文件拷贝至Jboss_HOME/server/default/deploy目录下.文件内容:
    <?xml version="1.0" encoding="UTF-8"?><!-- ===================================================================== -->
    <!--                                                                       -->
    <!--  JBoss Server Configuration                                           -->
    <!--                                                                       -->
    <!-- ===================================================================== --><!-- $Id: oracle-ds.xml,v 1.1.2.4 2003/09/17 03:46:01 ejort Exp $ -->
    <!-- ==================================================================== -->
    <!--  Datasource config for Oracle originally from Steven Coy             -->
    <!-- ==================================================================== -->
    <datasources>
      <local-tx-datasource>
        <jndi-name>txjndi</jndi-name>
        <connection-url>jdbc:oracle:thin:@10.194.134.147:1521:j2ee</connection-url>
        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
        <user-name>j2ee</user-name>
        <password>j2ee_123</password>
        <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
       </local-tx-datasource></datasources>三、 修改系统配置文件standardjboss.xml和standardjbosscmp-jdbc.xml
    修改standardjboss.xml文件内容:
    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE jbosscmp-jdbc PUBLIC
       "-//JBoss//DTD JBOSSCMP-JDBC 3.2//EN"
       "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_2.dtd"><!-- ===================================================================== -->
    <!--                                                                       -->
    <!--  Standard JBossCMP-JDBC Configuration                                 -->
    <!--                                                                       -->
    <!-- ===================================================================== --><!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.26 2003/09/09 13:02:18 lqd Exp $ --><jbosscmp-jdbc>   <defaults>
    <!—改为前面指定的数据源-->
          <datasource>java:/txjndi</datasource>
    <--指定数据源类型-->
          <datasource-mapping>Oracle8</datasource-mapping>      <create-table>true</create-table>
          <remove-table>false</remove-table>
          <read-only>false</read-only>
          <read-time-out>300000</read-time-out>
          <row-locking>false</row-locking>
          <pk-constraint>true</pk-constraint>
          <fk-constraint>false</fk-constraint>
          <preferred-relation-mapping>foreign-key</preferred-relation-mapping>
          <read-ahead>
             <strategy>on-load</strategy>
             <page-size>1000</page-size>
             <eager-load-group>*</eager-load-group>
          </read-ahead>
          <list-cache-max>1000</list-cache-max>
    省去一些内容…..

    修改standardjbosscmp-jdbc.xml的内容:
    <container-configurations>      <container-configuration>
             <container-name>Standard CMP 2.x EntityBean</container-name>
    <--开启Standard CMP EntieyBean服务-->
             <call-logging>true</call-logging>
             <invoker-proxy-binding-name>entity-rmi-invoker</invoker-proxy-binding-name>
             <sync-on-commit-only>false</sync-on-commit-only>
             <insert-after-ejb-post-create>false</insert-after-ejb-post-create>
             <container-interceptors>
                <interceptor>org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor</interceptor>
                <interceptor>org.jboss.ejb.plugins.LogInterceptor</interceptor>
                <interceptor>org.jboss.ejb.plugins.SecurityInterceptor</interceptor>
                <interceptor>org.jboss.ejb.plugins.TxInterceptorCMT</interceptor>
                <interceptor metricsEnabled="true">org.jboss.ejb.plugins.MetricsInterceptor</interceptor>
                <interceptor>org.jboss.ejb.plugins.EntityCreationInterceptor</interceptor>
                <interceptor>org.jboss.ejb.plugins.EntityLockInterceptor</interceptor>
                <interceptor>org.jboss.ejb.plugins.EntityInstanceInterceptor</interceptor>
                <interceptor>org.jboss.ejb.plugins.EntityReentranceInterceptor</interceptor>
                <interceptor>org.jboss.resource.connectionmanager.CachedConnectionInterceptor</interceptor>
                <interceptor>org.jboss.ejb.plugins.EntitySynchronizationInterceptor</interceptor>
                <interceptor>org.jboss.ejb.plugins.cmp.jdbc.JDBCRelationInterceptor</interceptor>
             </container-interceptors>
             <instance-pool>org.jboss.ejb.plugins.EntityInstancePool</instance-pool>
             <instance-cache>org.jboss.ejb.plugins.InvalidableEntityInstanceCache</instance-cache>
             <persistence-manager>org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager</persistence-manager>
             <locking-policy>org.jboss.ejb.plugins.lock.QueuedPessimisticEJBLock</locking-policy>
             <container-cache-conf>
                <cache-policy>org.jboss.ejb.plugins.LRUEnterpriseContextCachePolicy</cache-policy>
                <cache-policy-conf>
                   <min-capacity>50</min-capacity>
                   <max-capacity>1000000</max-capacity>
                   <overager-period>300</overager-period>
                   <max-bean-age>600</max-bean-age>
                   <resizer-period>400</resizer-period>
                   <max-cache-miss-period>60</max-cache-miss-period>
                   <min-cache-miss-period>1</min-cache-miss-period>
                   <cache-load-factor>0.75</cache-load-factor>
                </cache-policy-conf>
             </container-cache-conf>
             <container-pool-conf>
                <MaximumSize>100</MaximumSize>
             </container-pool-conf>
             <commit-option>B</commit-option>
          </container-configuration>如果开启其它服务可修改相应的<call-logging>值.
      

  7.   

    我非常感谢AllError(错误大全) 、eyeieye(魔之眼) ,并且也感谢大家的参与,谢谢大家!
    结帖!!