Re: Shark 1.1 Postgresql - Problem with variablevaluebool

Hi,
I changed the BIT fields with VARCHAR(1) in generated SQL for the 
creation of the PostgreSQL database. After this I run configure.bat 
again. Now it seems to be working.
In my opinion BIT is not correct type for the fields where it is used. I 
think the BOOLEAN is better. But it does not work with BOOLEAN either. 
May be, because Shark uses PreparedStatements for persistence but does 
not sets correct data types for parameters.

Regards
Lyubomir

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