[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[HelloW]

so it was a user problem

and since the birt reporting is installed in /data/birt it took so long to find 
the actual culprits:

I changed this file -> 
server.home\server\default\data\birt\overall_activity.rptdesign


  | 
  | 
  | org.hsqldb.jdbcDriver
  | jdbc:hsqldb:hsql://localhost:1701
  | sa
  | java:/JbpmDS
  | 
  | 
  | 

to 

  | 
  | 
  | java:/JbpmDS
  | 
  | 

and server.home\server\default\data\birt\specific_system_overview.rptdesign

from 
  | 
  | 
  | org.hsqldb.jdbcDriver
  | jdbc:hsqldb:hsql://localhost:1701
  | sa
  | java:/JbpmDS
  | 
  | 

to

  | 
  | java:/JbpmDS
  | 
  | 

and walla...the login failures disappear

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4256113#4256113

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4256113
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[HelloW]

http://www.mail-archive.com/jboss-user@lists.jboss.org/msg147697.html

That seems to be the same problem I am getting


View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255890#4255890

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255890
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[HelloW]

yep I think you are right.I found that user in 
server\default\deploy\hsqldb-ds.xml

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255872#4255872

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255872
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[kukeltje]

user sa is normally one for hsqldb so that leads me to think (again) that a 
different config file is used. Can you do a zgrep or something on all jbpm and 
console related jar's?

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255774#4255774

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255774
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[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.(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.(PhysicalConnection.java:508)
  | at oracle.jdbc.driver.T4CConnection.(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.(ConnectionJDBC2.java:357)
  | at 
net.sourceforge.jtds.jdbc.ConnectionJDBC3.(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
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[kukeltje]

Or change the queries in the source so we can have a look to and maybe fix it 
on our side ;-)

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255700#4255700

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255700
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[HelloW]

I think you right. Just spoke with the DBA who turned Auditing on. He pulled 
some of the queries which are being executed and they seem to have syntax 
issues with Sybase.

Thanks for help dudes

Now I just need to convince them to let me use mySQL or something which 
actually is working :D

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255689#4255689

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255689
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[jbarrez]

mmm it seems that the SQL queries that are used are no 'sybase-compatible', 
which could be true since we don't have Sybase in our QA setup (yet). So I'm 
afraid it's a specific Sybase/driver issue here ...

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255679#4255679

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255679
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[HelloW]

"Another piece of info: If I use jConnect then on that particular tab 
(Reporting) it shows:" 

is meant to read

"Another piece of info: If I use jTDS then on that particular tab (Reporting) 
it shows:"

Apologies...cannot seem to edit original post

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255570#4255570

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255570
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[HelloW]

jbarrez: yep i did replace it :) here's a few of the diff permutations I have 
tried

XA DS with Jconnect - (Tried jconn3.jar and jconnect60-exclude.jar separately)

  | 
  | 
  |   
  | JbpmDS
  | 
com.sybase.jdbc3.jdbc.SybXADataSource
  | Tds
  | xx
  | 7550
  | WORKFLOW_TEST
  | 
  | 
TRANSACTION_READ_COMMITTED
  | 
  | 
  | 
  | 
  | wflowuser
  | newmed
  | 
org.jboss.resource.adapter.jdbc.vendor.SybaseExceptionSorter
  | Sybase
  |   
  | 
  | 

DS with jTDS (tried jtds.jar and jtds-1.2.3.jar separately)

  |   
  | JbpmDS
  | 
jdbc:jtds:sybase://x:7550/WORKFLOW_TEST
  | net.sourceforge.jtds.jdbc.Driver
  | wflowuser
  | newmed
  | 
  | 
  | 
TRANSACTION_READ_COMMITTED
  | 
  | 
  | 
  | 
  | 
  | Sybase
  | 
  |   
  | 

kukeltje: Yep I can log onto the console using alex/password, which is part of 
the example.identities.sql script I used to insert test data. And can see 
process lists, etc. The only tab which causes the error is Reporting -> 
Available Reports -> Processes

Another piece of info: If I use jConnect then on that particular tab 
(Reporting) it shows:

  | System overview
  | 
  | Report creation:
  | Wed Sep 16 16:13:16 CAT 2009
  | Process summary
  | Total Process Definitions:
  |  
  | Active Instances:
  |  
  | Total Instances:
  |  
  | Process details
  | Process definition
  | # Total instances
  | # Active instances
  | Process definition usage metrics
  | Process performance metrics
  | 
  | Report generated by jBPM console at  2009-09-16 16:13:16.978
  | The following items have errors:
  | 
  | Grid (id = 353):
  | + Column binding "process_definition" has referred to a data set column 
"process_definition" which does not exist.
  | 
  | Data (id = 309):
  | + Column binding "process_definition" has referred to a data set column 
"process_definition" which does not exist.
  | 
  | Data (id = 311):
  | + Column binding "process_definition" has referred to a data set column 
"process_definition" which does not exist.
  | 
  | Data (id = 310):
  | + Column binding "process_definition" has referred to a data set column 
"process_definition" which does not exist.
  | 
  | Table process_counts_table:
  | + Column binding "process_definition" has referred to a data set column 
"process_definition" which does not exist.
  | 
  | Chart NewChart:
  | + Column binding "process_definition" has referred to a data set column 
"process_definition" which does not exist.
  | 
  | Chart NewChart1:
  | + Column binding "PROCESS_DEFINITION" has referred to a data set column 
"PROCESS_DEFINITION" which does not exist.
  | 

Error in log with jTDS: 

  | 2009-09-16 16:20:31,106 WARN  
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable 
while attempting to get a new connection: null
  | org.jboss.resource.JBossResourceException: Could not create connection; - 
nested throwable: (java.sql.SQLException: Login failed)
  | at 
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:190)
  | at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:619)
  | at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:264)
  | at 
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:575)
  | at 
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:347)
  | at 
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:330)
  | at 
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:402)
  | at 
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:849)
  | at 
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:104)
  | at 
org.eclipse.birt.report.data.oda.jdbc.JndiDataSource.getDataSourceConnection(JndiDataSource.java:159)
  | at 
org.eclipse.birt.report.data.oda.jdbc.JndiDataSource.getConnection(JndiDataSource.java:133)
  | at 
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getJndiDSConnection(JDBCDriverManager.java:284)
  | at 
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:205)
  | at 
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:179)
  | at 
org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:220)
  | at 
org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:151)
  | at 
org.eclipse.datatools.connectivity.oda.c

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[kukeltje]

Just to make sure I did not interpret something wrong... you ARE able to use 
the console right? Start new processes, see process lists etc.. At least that 
was my (maybe wrong as it seems now) assumption by what you posted before.



View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255548#4255548

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255548
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[jbarrez]

I mean this file:

jboss-5.0.0.GA/server/default/deploy/jbpm/jbpm-hsqldb-ds.xml

You need to remove this file and replace it with one suited for your database. 
There are examples in the /doc folder of JBoss, I believe.

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255544#4255544

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255544
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[HelloW]

kukeltje: hehehe. yep i think so as well
jbarrez: That's what i thought. do you mean this file -> 
{jboss.home}\server\default\deploy\jbpm\jbpm-service.sar\jbpm.hibernate.cfg.xml

my file currently looks like this: 


  | 
  | 
  | http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd";>
  | 
  | 
  | 
  | 
  | org.hibernate.dialect.SybaseDialect
  | java:JbpmDS
  | jbpmtest
  | jbpmtest
  | org.hibernate.transaction.JTATransactionFactory
  | org.hibernate.transaction.JBossTransactionManagerLookup
  | UserTransaction
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 
  | 

i added these two lines to try force the user but still no luck:

  | jbpmtest
  | jbpmtest
  | 

Funny thing is that if I use mySQL (instead of sybase) then it appears to work 
save for a similar error. It complains of a user called 'sa'@localhost not 
existing. If I add the two lines to the hbm file then it either works with that 
user or I have to manually create a user 'sa' with no password and the error 
disappears.

I suspect the reporting engine is being a weird with the user/pass it uses for 
the db. Any clue how to force it to use a specific user/pass (apart from adding 
those two lines - assuming that is not the right solution)?

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255542#4255542

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255542
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[jbarrez]

The BIRT reporting engine uses a JNDI datasource: java:/JbpmDS. So you'll have 
to change the datasource file that is installed which point by default to the 
hsqldb.

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255530#4255530

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255530
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[kukeltje]

phew. hahaha

The only thing I can think of is that the reporting uses a different connection 
and accompanying configuration then you and I think it does. But I don't have 
any knowledge in that area. As mentioned before, You might have more luck in 
the console forum

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255529#4255529

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255529
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[HelloW]

Scratch that - IE finally succumbed and threw the error again.

Yeah I agree...it doesn't make sense.

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255521#4255521

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255521
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[kukeltje]

A datasource not being able to get a connection on an AS being related to the 
type of browser being used??? Hmmm... I can hardly imagine that. (not that I 
know what the cause may be) Unless there is a bug in the pages, but since I 
know none of the developers working on the console/reports use Windows 
(Mac/Linux) I cannot imagine it is a bug in that area either.

You may want to try the console forum 
https://www.jboss.org/community/wiki/BPMConsole

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255497#4255497

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255497
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[HelloW]

Ok, this is insanely weird but it in Firefox & Chrome the error keeps popping 
up. I then tried IE and no errorso it's a browser issue?

That makes me a sad panda :(

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255478#4255478

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255478
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[HelloW]

alas DTM is enabled on the DB (well according to the DBA) so i'm still unsure 
as to what is causing this error...

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255248#4255248

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255248
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[HelloW]

thanks for quick reply, kukeltje :)

well I can login to the console using alex/password which is part of the test 
data inserted into the DB. All the other menu tabs seem to work fine and don't 
throw any errors. 

Once I get to the reporting tab then the error shows up in the log file. A 
similar error appeared when I tried JBPM 4.1 + mySQL + Jboss 5.1.0GA. It said 
user 'sa'@localhost was not valid, etc. That's when I inserted the jbpmtest 
user/pass into the jbpm.hibernate.cfg.xml (overriding the 'sa' user?). That 
solved it on mySQL but not for Sybase.

I've attached more of the log, from the point where you click on the Reporting 
Tab -> Available Reports -> Processes

2009-09-14 13:01:20,375 INFO  
[org.eclipse.birt.report.model.metadata.StructRefPropertyType] 
(http-127.0.0.1-8080-4) The value of the structure property is a string
  | 2009-09-14 13:01:20,422 INFO  
[org.eclipse.birt.report.model.metadata.StructRefPropertyType] 
(http-127.0.0.1-8080-4) The value of the structure property is a string
  | 2009-09-14 13:01:23,562 INFO 
[org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager] 
(http-127.0.0.1-8080-4) Found JDBC driverinfo extension: 
driverClass=org.apache.derby.jdbc.EmbeddedDriver, connectionFactory=null
  | 2009-09-14 13:01:23,578 INFO  
[org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager] 
(http-127.0.0.1-8080-4) Found JDBC driverinfo extension: 
driverClass=org.eclipse.birt.report.data.oda.sampledb.Driver, 
connectionFactory=org.eclipse.birt.report.data.oda.sampledb.SampleDBJDBCConnectionFactory
  | 2009-09-14 13:01:23,609 WARN  
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] 
(http-127.0.0.1-8080-4) Destroying connection that could not be successfully 
matched: 
org.jboss.resource.connectionmanager.txconnectionmanager$txconnectioneventliste...@1f9f777[state=normal
 mc=org.jboss.resource.adapter.jdbc.local.localmanagedconnect...@1a7125b 
handles=0 lastUse=1252926080375 permit=false trackByTx=false 
mcp=org.jboss.resource.connectionmanager.jbossmanagedconnectionpool$onep...@1a632f5
 
context=org.jboss.resource.connectionmanager.internalmanagedconnectionp...@5b9ec1
 
xaresource=org.jboss.resource.connectionmanager.txconnectionmanager$localxaresou...@1e5c671
 txSync=null]
  | 2009-09-14 13:01:23,625 WARN  
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] 
(http-127.0.0.1-8080-4) Destroying connection that could not be successfully 
matched: 
org.jboss.resource.connectionmanager.txconnectionmanager$txconnectioneventliste...@23cda8[state=normal
 mc=org.jboss.resource.adapter.jdbc.local.localmanagedconnect...@1139a51 
handles=0 lastUse=1252926071376 permit=false trackByTx=false 
mcp=org.jboss.resource.connectionmanager.jbossmanagedconnectionpool$onep...@1a632f5
 
context=org.jboss.resource.connectionmanager.internalmanagedconnectionp...@5b9ec1
 
xaresource=org.jboss.resource.connectionmanager.txconnectionmanager$localxaresou...@1b84919
 txSync=null]
  | 2009-09-14 13:01:23,641 WARN  
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] 
(http-127.0.0.1-8080-4) Throwable while attempting to get a new connection: null
  | org.jboss.resource.JBossResourceException: Could not create connection; - 
nested throwable: (java.sql.SQLException: Login failed)
  | at 
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)
  | at 
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)
  | at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:633)
  | at 
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:267)
  | at 
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:622)
  | at 
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
  | at 
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
  | at 
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
  | at 
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
  | at 
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:104)
  | at 
org.eclipse.birt.report.data.oda.jdbc.JndiDataSource.getDataSourceConnection(JndiDataSource.java:159)
  | at 
org.eclipse.birt.report.data.oda.jdbc.JndiDataSource.getConnection(JndiDataSource.java:133)
  | at 
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getJndiDSConnection(JDBCDriverManager.java:284)
  | at 
org.eclipse.birt.report.data.oda.jdbc.JDBCDr

[jboss-user] [jBPM Users] - Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

[kukeltje]

can you get access to the DB at all? I see no jBPM related line in the 
stacktrace so I suggest to make e.g. a very small test in the AS to check that 
(or test the connection from e.g. JOPR)

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255035#4255035

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255035
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user