I found the solution to my problem. It raises a minor database portability
issue.
The root of the problem turned out to be a NullPointerException that the
PGSQL driver threw in ejbStore. It turns out that although Oracle is OK
with:
PreparedStatement.setObject(x, null, Types.TYPE);
PostgreSQL isn't. PreparedStatement.setNull(x, Types.TYPE); seems to work
in both.
Hope this is useful to someone,
jim
> Hi,
> I'm trying to port our J2EE app from NT/Oracle to Debian/Postgresql. The
> postgres datasource is connecting fine on startup, but when any
> ejbCreate method is called (i.e. an INSERT is called) postgresql throws
> this:
>
> java.lang.reflect.UndeclaredThrowableException:
> javax.transaction.RollbackException: Unable to commit, tx=XidImpl
> [FormatId=257, GlobalId=lovestuffer.internal.paribus.com//3,
> BranchQual=] status=STATUS_ROLLEDBACK
> at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368)
> at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76)
> at
>
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:318)
> ...
>
> I've been able to create and drop tables through jdbc with the ant task
> "sql", I have the right driver, and the same application deploys and
> runs successfully with an Oracle datasource.
>
> I'm confused! Any tips gladly received.
>
> jim
>
> [EMAIL PROTECTED]
> Paribus
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
>
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
