You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@geronimo.apache.org by Mohammad Shamsi <m....@gmail.com> on 2008/04/06 12:12:42 UTC
Re: Delivery Status Notification (Failure)
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
Re: Delivery Status Notification (Failure)
Posted by Mohammad Shamsi <m....@gmail.com>.
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 <m....@gmail.com> 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