[jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA
by HelloW
kukeltje: hehehe, will see what i can do
On a related note I tried Oracle and mySQL now and I think I have found a pattern.
When you access the reporting screen it displays this on mySQL:
Caused by: java.sql.SQLException: Access denied for user 'sa'@'localhost' (using password: NO)
| at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
| at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
| at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
| at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421)
| at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
| at com.mysql.jdbc.Connection.createNewIO(Connection.java:2775)
| at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
| at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
| at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:425)
| at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:140)
| at com.mysql.jdbc.jdbc2.optional.MysqlXADataSource.getXAConnection(MysqlXADataSource.java:58
| )
For Oracle:
| Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
|
| at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
| at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
| at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
| at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
| at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:406)
| at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
| at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:799)
| at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:368)
| at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
| at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
| at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
| at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
| at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:275)
| at oracle.jdbc.xa.client.OracleXADataSource.getPooledConnection(OracleXADataSource.java:454
|
| at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:159)
| at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:130)
| at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XA
| anagedConnectionFactory.java:137)
|
For Sybase:
| Caused by: java.sql.SQLException: Login failed
| at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
| at net.sourceforge.jtds.jdbc.TdsCore.tdsLoginAckToken(TdsCore.java:2956)
| at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2264)
| at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:603)
| at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:357)
| at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
| at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
| at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(Loca
| lManagedConnectionFactory.java:172)
|
I think it's trying to use a user called sa with null password. If you add that to mySQL then the error disappears. Sybase and Oracle won't let me add users with no passwords (for good reason :P).
I think this might be the actual problem...any clue where to force a different user? Or where it is setting this user.
I thought it was in jbpm.hibernate.cfg.xml but that doesn't seem to work :(
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255745#4255745
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255745
17 years
[jBPM Users] - Re: Error from Fork element with transitions to FreeMarker f
by pektop
"jbarrez" wrote : Oleg could you provide me the complete process?
|
Sure, here it is.
<?xml version="1.0" encoding="UTF-8"?>
|
| <process name="VacationRequest_bug" xmlns="http://jbpm.org/4.0/jpdl">
| <start form="org/jbpm/examples/taskform_bug/request_vacation.ftl" g="170,16,48,48" name="start">
| <transition to="fork1"/>
| </start>
| <task candidate-users="mike,peter" form="org/jbpm/examples/taskform_bug/verify_request.ftl" g="16,176,178,52" name="verify_request">
| <transition name="accept" to="join1" g="-52,-19"/>
| </task>
| <end g="170,340,48,48" name="vacation_accepted"/>
| <task candidate-users="mike,peter" form="org/jbpm/examples/taskform_bug/verify_request2.ftl" name="verify_request2" g="226,176,114,52">
| <transition name="accept" to="join1" g="-52,-19"/>
| </task>
| <fork name="fork1" g="170,96,48,48">
| <transition to="verify_request"/>
| <transition to="verify_request2"/>
| </fork>
| <join name="join1" g="170,260,48,48">
| <transition to="vacation_accepted"/>
| </join>
| </process>
Hope this will help in investigation.
BR
Oleg Ladizhensky
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255711#4255711
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255711
17 years