sorry !!! i was forgat to add Driver property to my db plan. thats work now. and it is faster than weblogic and glass fish.
thanks David. On Sun, Apr 6, 2008 at 2:12 AM, Mohammad Shamsi <[EMAIL PROTECTED]> wrote: > Hi David, > > when i change my database to embeded Derby, it work fine. > does OpenJPA has problem with MySQL ?????? > > this is my mysql db plan : > > *<?xml version="1.0" encoding="UTF-8"?> > <connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2";> > <dep:environment xmlns:dep=" > http://geronimo.apache.org/xml/ns/deployment-1.2";> > <dep:moduleId> > <dep:groupId>console.dbpool</dep:groupId> > <dep:artifactId>BankPool</dep:artifactId> > <dep:version>1.0</dep:version> > <dep:type>rar</dep:type> > </dep:moduleId> > <dep:dependencies> > <dep:dependency> > <dep:groupId>mysql</dep:groupId> > <dep:artifactId>mysql-connector-java</dep:artifactId> > <dep:version>5.1.5</dep:version> > <dep:type>jar</dep:type> > </dep:dependency> > </dep:dependencies> > </dep:environment> > <resourceadapter> > <outbound-resourceadapter> > <connection-definition> > > <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface> > <connectiondefinition-instance> > <name>BankPool</name> > <config-property-setting > name="Password">test</config-property-setting> > <config-property-setting > name="UserName">test</config-property-setting> > <config-property-setting > name="ConnectionURL">jdbc:mysql://192.168.3.79:3306/test > </config-property-setting> > <connectionmanager> > <local-transaction/> > <single-pool> > <max-size>10</max-size> > <min-size>1</min-size> > <match-one/> > </single-pool> > </connectionmanager> > </connectiondefinition-instance> > </connection-definition> > </outbound-resourceadapter> > </resourceadapter> > </connector> > * > and here is my Derby DB plan :: > > > <?xml version="1.0" encoding="UTF-8"?> > <connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.1";> > <dep:environment xmlns:dep=" > http://geronimo.apache.org/xml/ns/deployment-1.1";> > <dep:moduleId> > <dep:groupId>console.dbpool</dep:groupId> > <dep:artifactId>BankPool</dep:artifactId> > <dep:version>1.0</dep:version> > <dep:type>rar</dep:type> > </dep:moduleId> > <dep:dependencies> > <dep:dependency> > <dep:groupId>org.apache.geronimo.configs</dep:groupId> > <dep:artifactId>system-database</dep:artifactId> > <dep:type>car</dep:type> > </dep:dependency> > </dep:dependencies> > </dep:environment> > <resourceadapter> > <outbound-resourceadapter> > <connection-definition> > > <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface> > <connectiondefinition-instance> > <name>BankPool</name> > <config-property-setting > name="Driver">org.apache.derby.jdbc.EmbeddedDriver</config-property-setting> > <config-property-setting > name="UserName">app</config-property-setting> > <config-property-setting > name="ConnectionURL">jdbc:derby:BankDB</config-property-setting> > <connectionmanager> > <local-transaction/> > <single-pool> > <max-size>10</max-size> > <min-size>0</min-size> > <match-one/> > </single-pool> > </connectionmanager> > </connectiondefinition-instance> > </connection-definition> > </outbound-resourceadapter> > </resourceadapter> > </connector> > > > -- > sincerely yours > M. H. Shamsi > -- sincerely yours M. H. Shamsi
