Hi, thanks i would like to have clear what i have to modify or add to
geronimo-ds.xml .. if i want to connect to Mysql 5.0

i think ..is not enought what say in

http://bpms.intalio.com/reference-guides/intalio-bpms-server-installin...







com.intalio.bpms
BPMSDS
1.0
rar



mysql
mysql-connector
5.0.4
jar






javax.sql.DataSource

BPMSDS
${db.driver}
${db.login}
${db.password}
${db.url}



10
0



jdbc/BPMSDB







thaks a lot

Luz,
Do you want to configure Intalio|BPMS Server with MySQL?, Then visit this page, I hope it helps you.

Thanks,
Shivanand.

Shivanad,


which one page??

http://bpms.intalio.com/reference-guides/intalio-bpms-server-installin...


Thanks,
Shivanand.

Shivanad


i was doing it but i get:

Microsoft Windows XP [Versión 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrador>cd C:\intalio-bpms-server-5.1.0.019\bin

C:\intalio-bpms-server-5.1.0.019\bin>deploy.bat --offline redeploy ..\repository
\org\tranql\tranql-connector-ra\1.3\tranql-connector-ra-1.3.rar ..\databases\MyS
QL\geronimo-ds.xml
Using GERONIMO_BASE: C:\intalio-bpms-server-5.1.0.019
Using GERONIMO_HOME: C:\intalio-bpms-server-5.1.0.019
Using GERONIMO_TMPDIR: var\temp
Using JRE_HOME: C:\Archivos de programa\Java\jdk1.5.0_14\jre
No ModuleID or TargetModuleID provided. Attempting to guess based
on the content of the plan.
Attempting to use ModuleID 'com.intalio.bpms/BPMSDS/1.0/rar'
03:02:20,031 WARN [ConnectorPlanRectifier] Your connector plan has obsolete ele
ments or attributes in it. Please remove version attributes, global-jndi-name e
lements, and credential-interface elements
03:02:20,281 WARN [ConnectorModuleBuilder] Problem loading driver class '${db.d
river}', possibly due to a missing dependency on the driver jar!!
java.lang.ClassNotFoundException: ${db.driver} in classloader com.intalio.bpms/B
PMSDS/1.0/rar
at org.apache.geronimo.kernel.config.MultiParentClassLoader.loadOptimize
dClass(MultiParentClassLoader.java:428)
at org.apache.geronimo.kernel.config.MultiParentClassLoader.loadClass(Mu
ltiParentClassLoader.java:278)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at org.apache.geronimo.connector.deployment.ConnectorModuleBuilder.addOu
tboundGBeans(ConnectorModuleBuilder.java:856)
at org.apache.geronimo.connector.deployment.ConnectorModuleBuilder.addCo
nnectorGBeans(ConnectorModuleBuilder.java:551)
at org.apache.geronimo.connector.deployment.ConnectorModuleBuilder.initC
ontext(ConnectorModuleBuilder.java:483)
at org.apache.geronimo.connector.deployment.ConnectorModuleBuilder$$Fast
ClassByCGLIB$$a535b6aa.invoke()
at net.sf.cglib.reflect.FastMethod.invoke(FastMethod.java:53)
at org.apache.geronimo.gbean.runtime.FastMethodInvoker.invoke(FastMethod
Invoker.java:38)
at org.apache.geronimo.gbean.runtime.GBeanOperation.invoke(GBeanOperatio
n.java:124)
at org.apache.geronimo.gbean.runtime.GBeanInstance.invoke(GBeanInstance.
java:830)
at org.apache.geronimo.gbean.runtime.RawInvoker.invoke(RawInvoker.java:5
7)
at org.apache.geronimo.kernel.basic.RawOperationInvoker.invoke(RawOperat
ionInvoker.java:35)
at org.apache.geronimo.kernel.basic.ProxyMethodInterceptor.intercept(Pro
xyMethodInterceptor.java:96)
at org.apache.geronimo.j2ee.deployment.ActivationSpecInfoLocator$$Enhanc
erByCGLIB$$9d3accf5.initContext()
at org.apache.geronimo.j2ee.deployment.EARConfigBuilder.buildConfigurati
on(EARConfigBuilder.java:576)
at org.apache.geronimo.j2ee.deployment.EARConfigBuilder$$FastClassByCGLI
B$$38e56ec6.invoke()
at net.sf.cglib.reflect.FastMethod.invoke(FastMethod.java:53)
at org.apache.geronimo.gbean.runtime.FastMethodInvoker.invoke(FastMethod
Invoker.java:38)
at org.apache.geronimo.gbean.runtime.GBeanOperation.invoke(GBeanOperatio
n.java:124)
at org.apache.geronimo.gbean.runtime.GBeanInstance.invoke(GBeanInstance.
java:830)
at org.apache.geronimo.gbean.runtime.RawInvoker.invoke(RawInvoker.java:5
7)
at org.apache.geronimo.kernel.basic.RawOperationInvoker.invoke(RawOperat
ionInvoker.java:35)
at org.apache.geronimo.kernel.basic.ProxyMethodInterceptor.intercept(Pro
xyMethodInterceptor.java:96)
at org.apache.geronimo.j2ee.deployment.CorbaGBeanNameSource$$EnhancerByC
GLIB$$fb9470ac.buildConfiguration()
at org.apache.geronimo.deployment.Deployer.deploy(Deployer.java:304)
at org.apache.geronimo.deployment.Deployer.deploy(Deployer.java:126)
at org.apache.geronimo.deployment.Deployer$$FastClassByCGLIB$$734a235d.i
nvoke()
at net.sf.cglib.reflect.FastMethod.invoke(FastMethod.java:53)
at org.apache.geronimo.gbean.runtime.FastMethodInvoker.invoke(FastMethod
Invoker.java:38)
at org.apache.geronimo.gbean.runtime.GBeanOperation.invoke(GBeanOperatio
n.java:124)
at org.apache.geronimo.gbean.runtime.GBeanInstance.invoke(GBeanInstance.
java:865)
at org.apache.geronimo.kernel.basic.BasicKernel.invoke(BasicKernel.java:
239)
at org.apache.geronimo.deployment.plugin.local.AbstractDeployCommand.doD
eploy(AbstractDeployCommand.java:116)
at org.apache.geronimo.deployment.plugin.local.RedeployCommand.redeployS
ameConfiguration(RedeployCommand.java:225)
at org.apache.geronimo.deployment.plugin.local.RedeployCommand.run(Redep
loyCommand.java:101)
at java.lang.Thread.run(Thread.java:595)
Uninstalled com.intalio.bpms/BPMSDS/1.0/rar
Deployed com.intalio.bpms/BPMSDS/1.0/rar
Started com.intalio.bpms/BPMSDS/1.0/rar
Redeployed com.intalio.bpms/BPMSDS/1.0/rar
[] received stop signal


C:\intalio-bpms-server-5.1.0.019\bin>





my geronimo-ds is in this way:








com.intalio.bpms
BPMSDS
1.0
rar



mysql
mysql-connector
5.0.4
jar






javax.sql.DataSource

BPMSDS
${db.driver}
${db.login}
${db.password}
${db.url}



10
0



jdbc/BPMSDB


conexionmysql
com.mysql.jdbc.Driver
root
julian
jdbc:mysql://localhost:3306/bpms



10
0



jdbc/BPMSDB









In designer time i created a conexion named as "conexionmysql" for that reason i add to before file conexionmysql ...etc..


i have a folder named as conexionmysql under ...var/config/jdbc-conector and ile named connection properties like this:

#The database type
#Available types - DER10 for DERBY, MYS5 for MySQL , ORA9 for Oracle.
com.intalio.bpms.connector.jdbc.db.type=MYS5

# Data source type: "jndi" or "driver"
com.intalio.bpms.connector.jdbc.ds.type=driver

# Whether to allow dynamic (ad-hoc) queries or restrict to predefined, server-side, set of queries
com.intalio.bpms.connector.jdbc.allowDynamicSQL=true

# JDBC driver data source (only used if data source type is "driver")
com.intalio.bpms.connector.jdbc.driver=com.mysql.jdbc.Driver
com.intalio.bpms.connector.jdbc.url=jdbc:mysql://localhost:3306/bpms

# Other JDBC driver specific properties here;
# these will be passed to underlying driver as-is
user=root
password=julian




WHAT IS WRONG..???? THANKS A LOT

Shivanad,

i attach geronimo-ds.xml


i think i have some thing wrong here..


would you like check it please