[jboss-jira] [JBoss JIRA] Commented: (JBRULES-3169) Fix unit tests for drools-persistence-jpa on supported databases

[Marco Rietveld (JIRA)]

    [ https://issues.jboss.org/browse/JBRULES-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12620629#comment-12620629 ] 

Marco Rietveld commented on JBRULES-3169:
-----------------------------------------

- Oracle unit tests are complain about the lack of sequences. 
- Postgresql unit tests complain about dealing with Large Objects (Postgresql impl. of @Lob) outside of transactions. 
- Sybase tests throw the following which probably also has to do with @Lob/byte []'s: 
{code}
Caused by: java.lang.UnsupportedOperationException: The method com.sybase.jdbc3.jdbc.SybResultSet.getBlob(String) is not supported and should not be called.
	at com.sybase.jdbc3.jdbc.ErrorMessage.raiseRuntimeException(Unknown Source)
	at com.sybase.jdbc3.utils.Debug.notSupported(Unknown Source)
	at com.sybase.jdbc3.jdbc.SybResultSet.getBlob(Unknown Source)
	at org.hibernate.type.ByteArrayBlobType.get(ByteArrayBlobType.java:87)
{code} 

> Fix unit tests for drools-persistence-jpa on supported databases
> ----------------------------------------------------------------
>
>                 Key: JBRULES-3169
>                 URL: https://issues.jboss.org/browse/JBRULES-3169
>             Project: Drools
>          Issue Type: Task
>      Security Level: Public(Everyone can see) 
>            Reporter: Marco Rietveld
>            Assignee: Marco Rietveld
>            Priority: Minor
>
> See https://hudson.qa.jboss.com/hudson/view/Drools%20jBPM/job/drools-persistence-db-matrix/
> Drools should support the following databases:
> - oracle 11g 
> - mssql 2008 R2
> - db2   9.7
> - mysql 5.1
> - mysql 5.0
> - postgresql 8.2.x
> - postgresql 8.3.x
> - postgresql 8.4.x
> It's not sure yet of Drools will support the following db's: 
> - sybase 1.5.x

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira