[Beginner's Corner] - using c3p0 as DefaultDS, can`t force ejb-deployer [EJBTimerS
by pnemec
jboss 4.2.3 GA, java version "1.6.0_15", c3p0-0.9.1.2.jar, linux
I am trying to use c3p0 as only datasource and I want to get rid of hsqldb-ds and mysql-ds.
c3p0-service.xml is default
| <server>
| <mbean code="com.mchange.v2.c3p0.jboss.C3P0PooledDataSource"
| name="jboss:service=PooledDS">
| <attribute name="JndiName">PooledDS</attribute>-->
| <attribute name="JdbcUrl">URL</attribute>
| <attribute name="DriverClass">com.mysql.jdbc.Driver</attribute>
| <attribute name="User">USER</attribute>
| <attribute name="Password">PWD</attribute>
| </mbean>
| </server>
|
I set ejb-deployer.xml - EJBTimerService to depend on this DS by change
| <depends optional-attribute name="DataSorce"> jboss.jca:service=DataSourceBinding,name=DefaultDS </depends>
|
to
| <depends>jboss.jca:service=DataSourceBinding,name=PooledDS</depends>
|
However I realize that c3p0 is not bound to jca, so I changed JNDI name of c3p0 bean to
| <mbean code="com.mchange.v2.c3p0.jboss.C3P0PooledDataSource"
| name="jboss.jca:service=DataSourceBinding,name=PooledDS">
|
This worked, but EJBTimerSerivce try look up DataSource with null:
| ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
| State: FAILED
| Reason: java.sql.SQLException: Failed to lookup data source: null
| I Depend On:
| jboss.jca:service=DataSourceBinding,name=PooledDS
|
This look like that EJBTimerService do not receive any DS. Putting back optional-argument=DataSource, helpd. Error message changed to:
| ObjectName: jboss.jca:service=DataSourceBinding,name=PooledDS
| State: NOTYETINSTALLED
| Depends On Me:
| jboss.ejb:service=EJBTimerService,persistencePolicy=database
|
I find out that I am not alone with this problem. For example in jboss forum
[url]
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3983368#3983368 [/url]
Which lead to inetersting solution http://www.nabble.com/c3p0-vs-JPA-injections-on-JBoss-td23722441.html . This helped me to fix EJBTimerService dependency on Pooled JNDI name.
I am just thinging is it possible to live completly without any -ds.xml data source?
[/url]
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255243#4255243
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255243
16 years, 7 months
[jBPM Users] - Re: Deploying processes on Tomcat
by sebastian.s
Okay, it's me again:
Where and how can I make the HSQLDB server used in the demo setup bind to the actual IP address and not to localhost? The reason: I am trying to deploy remote.
I have done the following for a workaround: I stopped Tomcat and I changed the supplied start-up script to start the HSQLDB from
java -cp hsqldb.jar org.hsqldb.Server -address localhost -port 1701 -dbname.0 jbpmDatabase
to
java -cp hsqldb.jar org.hsqldb.Server -address 0.0.0.0 -port 1701 -dbname.0 jbpmDatabase
Then I started the HSQLDB server using the start script and I could deploy my process from the remote system. Afterwards I stopped the HSQLDB server and restarted Tomcat.
Where can I set the address to bind to when the server is started in/by Tomcat?
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255242#4255242
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255242
16 years, 7 months