Hi Brian: Here is the SQL that was bombed...
SELECT A0.PROPERTY_VALUE,A0.PROPERTY_NAME,A0.ID FROM PROPERTY A0 WHERE A0. PROPERTY_NAME = ? I am surprised why the "SORT/Compare" is coming from? -----Original Message----- From: Brian McCallister [mailto:[EMAIL PROTECTED] Sent: Thursday, September 09, 2004 3:58 AM To: OJB Users List Subject: Re: MSSQL And OJB/Torque issue with image datatype..Will Velocity solve my problem? This is a limitation of (MS) SQL: > [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException > during the execution of the query (for a com.xxx.Property): The text, > ntext, and image data types cannot be compared or sorted, except when > using IS NULL or LIKE operator. What does the actual SQL look like, and what does the query you are running look like? -Brian On Sep 8, 2004, at 10:07 PM, Ajitesh Das wrote: > Hi: > > I want to store an *supersize* byte array into a db table. > > Below I have described the issues that I have. My question: > > How do I control SQL for Schema? Do I have to write my own Velocity > template and add that path to db.profile. > > > > > > > > I have made the followings changes: > > > > > > DB Type : MSSQL > > > > In db-schema.xml: > > > > <?xml version="1.0" encoding="ISO-8859-1"?> > > <!DOCTYPE database SYSTEM > "http://jakarta.apache.org/turbine/dtd/database.dtd";> > > <database name="@DATABASE_DEFAULT@" defaultIdMethod="none" baseClass="" >> > > <table name="PROPERTY" > > > <column name="ID" required="true" primaryKey="true" > type="INTEGER" > > > </column> > > <column name=" PROPERTY_NAME" required="true" > primaryKey="false" > type="VARBINARY" > > > </column> > > <column name="PROPERTY_VALUE" required="true" > primaryKey="false" > type="VARBINARY" > > > </column> > > </table> > > </database> > > > > It creates IMAGE datatype in MSSQL Server. > > > > In repository.xml: > > <class-descriptor > > class="com.xxx.Property" > > table="PROPERTY" > >> > > > > <attribute > > attribute-name="DB_NAME" > > attribute-value="mydb" > >> > > </attribute> > > > > <field-descriptor id="1" > > name="dbId" > > column="ID" > > jdbc-type="INTEGER" > > primarykey="true" > > nullable="false" > > indexed="true" > > autoincrement="true" > > locking="false" > > default-fetch="false" > > /> > > <field-descriptor id="2" > > name="propertyName" > > column="PROPERTY_NAME" > > jdbc-type="VARBINARY" > > primarykey="false" > > nullable="true" > > indexed="false" > > autoincrement="false" > > locking="false" > > default-fetch="false" > > conversion="com.xxx.yyy.Converter" > > /> > > <field-descriptor id="3" > > name="propertyValue" > > column="PROPERTY_VALUE" > > jdbc-type="VARBINARY" > > primarykey="false" > > nullable="true" > > indexed="false" > > autoincrement="false" > > locking="false" > > default-fetch="false" > > conversion="com.xxx.yyy.Converter" > > /> > > </class-descriptor> > > > > When I run simple queryI get the following exception: but running in > MySQL is fine. > > > > > > [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException > during the execution of the query (for a com.xxx.Property): The text, > ntext, and image data types cannot be compared or sorted, except when > using IS NULL or LIKE operator. > > The text, ntext, and image data types cannot be compared or sorted, > except when using IS NULL or LIKE operator. > > java.sql.SQLException: The text, ntext, and image data types cannot be > compared or sorted, except when using IS NULL or LIKE operator. > > > > at > net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.j > > ava:366) > > at > net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:1992) > > at > net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:1594) > > at > net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:490) > > at > net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement > > .java:262) > > at > net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPrep > > aredStatement.java:614) > > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown > > Source) > > at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown > Source) > > at > org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unk > > nown Source) > > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQue > > ry(Unknown Source) > > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery > > (Unknown Source) > > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorByQuery(U > > nknown Source) > > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getIteratorByQ > > uery(Unknown Source) > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
