Re: Shark 1.1 Postgresql - Problem with variablevaluebool

An update,

,I have tried using postgresql 8.0.3 with the same results.


David Bernard

David Bernard wrote:

> 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
>  
>

--
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