[
https://issues.apache.org/jira/browse/GERONIMO-5808?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12993432#comment-12993432
]
Matthias Weßendorf commented on GERONIMO-5808:
----------------------------------------------
Reading this wiki:
https://cwiki.apache.org/GMOxDOC30/jboss-to-geronimo-jdbc-migration.html
and this one:
https://cwiki.apache.org/GMOxDOC30/configuring-a-mysql-datasource.html
(before that, I was able to upload the drive to the repository, via the Admin
Console)
Now, I created this XML file, which contains my settings (including url to my
remote DB HOST):
<?xml version="1.0" encoding="UTF-8"?>
<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2"
xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2">
<dep:environment>
<dep:moduleId>
<dep:groupId>myapp</dep:groupId>
<dep:artifactId>my_users_ds</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.0.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>jdbc/CloudBees</name>
<config-property-setting
name="UserName">myUser</config-property-setting>
<config-property-setting
name="Password">myPassword</config-property-setting>
<config-property-setting
name="Driver">com.mysql.jdbc.Driver</config-property-setting>
<config-property-setting
name="ConnectionURL">jdbc:mysql://REMOTE_SERVER:3306/schema</config-property-setting>
<connectionmanager>
<xa-transaction>
<transaction-caching/>
</xa-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>
> org.apache.geronimo.common.DeploymentException: Unable to deploy
> tranql-connector-mysql-xa-1.4.rar: The plan is trying to set attributes:
> [Driver, ConnectionURL]
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: GERONIMO-5808
> URL: https://issues.apache.org/jira/browse/GERONIMO-5808
> Project: Geronimo
> Issue Type: Bug
> Security Level: public(Regular issues)
> Components: deployment
> Affects Versions: 3.0-M2
> Reporter: Matthias Weßendorf
>
> Trying to configure/deploy a remote database, I am getting this exception:
> org.apache.geronimo.common.DeploymentException: Unable to deploy
> tranql-connector-mysql-xa-1.4.rar: The plan is trying to set attributes:
> [Driver, ConnectionURL]
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira