problem with sybase column type text / urgent

View: New views
1 Messages — Rating Filter:   Alert me  

problem with sybase column type text / urgent

by mmistroni :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

hello all,
 i am using dbunit with sybase 12.5... and i am encountering big problems :(
i have one table whch has a column of type  'text' (sql_str)

here's xml i m using

<mytable    id="100"
                 sql_str="select * from table1"
              />

and i keep on getting the exception below...

can anyone help me out? it'll b a shame to drop use of dbunit just for 1 table which as a text field...

thanks and regards
 marco

com.exceptions.DbUnitTestException: com.sybase.jdbc2.jdbc.SybSQLException: Implicit conversion from datatype 'TEXT' to 'CHAR' is not allowed.  Use the CONVERT function to run this query.

        at com.utils.dbunit.CdrDevDbUnitTest.onTearDown(CdrDevDbUnitTest.java:94)
        at com.batches.tasks.SQLFlowTaskTest.onTearDown(SQLFlowTaskTest.java:34)
        at org.springframework.test.AbstractSingleSpringContextTests.tearDown(AbstractSingleSpringContextTests.java:120)
        at org.springframework.test.ConditionalTestCase.runBare(ConditionalTestCase.java:69)
        at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:40)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at com.intellij.rt.execution.application.AppMain.main(AppMain.java:90)
Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Implicit conversion from datatype 'TEXT' to 'CHAR' is not allowed.  Use the CONVERT function to run this query.
ca


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
dbunit-user mailing list
dbunit-user@...
https://lists.sourceforge.net/lists/listinfo/dbunit-user