[JCA/JBoss] - Re: Migration to MySQL
by bartek.polakowski
This is my mysql-ds file
<datasources>
| <local-tx-datasource>
| <jndi-name>MySqlDS</jndi-name>
| <connection-url>jdbc:mysql://mysql-hostname:3306/jbossdb</connection-url>
| <driver-class>com.mysql.jdbc.Driver</driver-class>
| <user-name>jboss</user-name>
| <password>jboss</password>
| <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
| <!-- should only be used on drivers after 3.22.1 with "ping" support
| <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
| -->
| <!-- sql to call when connection is created
| <new-connection-sql>some arbitrary sql</new-connection-sql>
| -->
| <!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers
| <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
| -->
|
| <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
| <metadata>
| <type-mapping>mySQL</type-mapping>
| </metadata>
| </local-tx-datasource>
|
| <local-tx-datasource>
| <jndi-name>Publication</jndi-name>
| <connection-url>jdbc:mysql://mysql-hostname:3306/ld_publication</connection-url>
| <driver-class>com.mysql.jdbc.Driver</driver-class>
| <user-name>java</user-name>
| <password>java</password>
| <min-pool-size>5</min-pool-size>
| <max-pool-size>15</max-pool-size>
| <idle-timeout-minutes>5</idle-timeout-minutes>
| <exception-sorter-class-name>com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter</exception-sorter-class-name>
| <valid-connection-checker-class-name>com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker</valid-connection-checker-class-name>
|
| </local-tx-datasource>
|
| </datasources>
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4047465#4047465
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4047465
18 years, 11 months
[JBossCache] - Re: JbossCache replication and ip multicast
by mckeno
Thank you very much for your information.
anonymous wrote : You should set your initial_hosts (in TCPPING) to the _other_ hosts in your cluster, not to point to yourself.
So there should always be a host which joins the cluster at first? (we have to make sure that this host always joins the cluster at the first time?)
Anyway, why do we need this so called initial_host? what does JbossCache as well as JGroups need it for? Wasn't it suppose that every host is "equal" in a replication group (or cluster) ?
For multicasting, i see that it uses the class D address range which is from 224.0.0.0 to 239.255.255.255. But as I am not so familiar with the network configuration and concept, I am wondering how could a host outside of the LAN "sees" the multicast address of a certain group inside a LAN.
In the JGroups document it saids :anonymous wrote :
| As a rule of thumb UDP is used as transport for LANs, whereas TCP is used for WANs.
So that is why I want to change my initial UDP config to TCP config (am I on the right track, anyway?)
Again, thanks for your reply
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4047464#4047464
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4047464
18 years, 11 months
[JBoss jBPM] - how to save processinstance
by cron@citiz.net
Question: I can't save the processinstance use the method of save
Scenarios: A web application.
There is a static helper class to createJbpmContext, and the workflow will begin after the first user logon, so there is always existing a jbpmContext in the helper class. we driver the workflow instance to go on, never call jbpmContext.close(), only call jbpmContext.save(processInstance).
throung the workflow goes on well, but no data were saved in the database.
I do know jbpmContext.close() can cause the system to save all process informations to database, but how I call some method to save the processinstance ? need I call jbpmContext.close() to end a certain workflow instance?
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4047462#4047462
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4047462
18 years, 11 months