Shark 1.1 Postgresql - Problem with variablevaluebool

Hi,

I have tried this with both lastest CVS and Shark 1.1.

Just trying to run JSPClient with Postgresql 7.4.7 backend I get the 
following exception when starting a process.

I guess a statement is being executed with the wrong format for a column 
of type BIT.

Note also that configure.sh does not update the 
"DatabaseManager.DB.sharkdb.Connection.Url" in the 
JSPClient/src/conf/Shark.conf" when building the sharworklisthandler 
WAR. (other db properties are updated)

David Bernard

2005-07-25 22:12:57,857: Process 
[key=4_Business_Example_Business_Example_Wor1,mgrname=Business_Example#1#Business_Example_Wor1] 
is created
2005-07-25 22:12:57,883: Rollback of Shark transaction happened.
java.sql.SQLException: ERROR: column "variablevaluebool" is of type bit 
but expression is of type character varying
        at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
        at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
        at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:388)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:329)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:281)
        at 
com.lutris.appserver.server.sql.standard.StandardDBConnection.executeUpdate(StandardDBConnection.java:467)
        at 
com.lutris.appserver.server.sql.CoreDO.executeInsert(CoreDO.java:345)
        at 
com.lutris.dods.builder.generator.dataobject.GenericDO.executeInsert(GenericDO.java:352)
        at 
org.enhydra.shark.instancepersistence.data.ProcessDataDO.executeInsert(ProcessDataDO.java:2269)
        at 
com.lutris.appserver.server.sql.standard.StandardDBTransaction.write(StandardDBTransaction.java:654)
        at 
com.lutris.appserver.server.sql.standard.StandardDBTransaction.commit(StandardDBTransaction.java:296)
        at 
org.enhydra.shark.transaction.SharkDODSTransaction.commit(SharkDODSTransaction.java:59)
        at 
org.enhydra.shark.SharkUtilities.commitTransaction(SharkUtilities.java:692)
        at 
org.enhydra.shark.SharkConnectionImpl.createProcess(SharkConnectionImpl.java:179)
        at test.JSPClientUtilities.processStart(JSPClientUtilities.java:116)
        at 
org.apache.jsp.index_jsp._jspService(org.apache.jsp.index_jsp:139)
        at 
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
        at 
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

--
You receive this message as a subscriber of the [email protected] mailing list.
To unsubscribe: mailto:[email protected]
For general help: mailto:[email protected]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws