AS400 java.sql.SQLException: SQL0519 error 1

[spafa9]

Hi Experts,

I am getting an error with my java application when running under jboss 3.2.2 with the jt400.jar... This is the error I am getting..

2004-04-16 06:48:49,621 INFO [cdukiah.cc.cmusa.selector.web.SelectorColumnHandler] java.sql.SQLException: [SQL0519] Pre
pared statement STMT0001 in use.
2004-04-16 06:48:49,701 WARN [org.jboss.tm.TransactionImpl] XAException: tx=TransactionImpl:XidImpl [FormatId=257, Glob
alId=UKIAHAPPS//259, BranchQual=] errorCode=XA_UNKNOWN(0)
org.jboss.resource.connectionmanager.JBossLocalXAException: Error trying to start local tx: ; - nested throwable: (org.j
boss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: [SQL0428] SQL statement
cannot be run.))

The as400 we are using is version 4 release 4 The app runs fine on the other as400 that is running version4 release 5. Does anyone know of a fix that I can do? I have tried downloading a current jt400.jar driver and that didnt work. I also tried setthing the lazy close property and that also didnt work. Any suggestions?

 

[Drella]

hi all,
we've exactily the same problem, but using Visual Basic .NET. it'd be great if someone could help us. The error is just the same above and it happens like that.

thanks

 

[spafa9]

Hi Drella,

We ended up having the client upgrade to release 5 to solve the issue. Luckily we were able to have them upgrade. An option to think about though.

spafa9

 

[Drella]

I did it too and it worked!. One problem left. Thanks

Drella

 

[spafa9]

No problem glad it worked for you also!

spafa9