Hi,
I have currently ported data from mySQL to SQL server. I have a bean called
"Account" and using xdeclet to generated ojb repository.
OR mapping looks just fine . I have jdbc-type INTEGER for all int fields in
database and VARCHAR for all Varchar fields.
In my bean I have 3 java.sql.Date fields which has DATE as jdbc-type in
repository and 2 java.sql.Timestamp fields which has jdbc-type Timestamp.
All of these five fields have data type "datetime" at MS SQL level.
When I insert a record in this table using ojb it works fine but when I
select a record using follwong method
public Account retrieveAccountByUsername(String username) {
PersistenceBroker broker =
PersistenceBrokerFactory.defaultPersistenceBroker();
broker.beginTransaction();
Criteria c = new Criteria();
c.addEqualTo("user_name", username);
c.addEqualTo("active","1");
QueryByCriteria query = new QueryByCriteria(Account.class, c);
Account ac = (Account)broker.getObjectByQuery(query);
broker.commitTransaction();
broker.close();
System.out.println(ac.getLast_name());
return ac;
}
it gives the following error message
ava.sql.SQLException: Not supported type with setObject:2,java.lang.String,4
at com.inet.tds.c.setObject(Unknown Source)
at com.inet.tds.c.setObject(Unknown Source)
at
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Un
known Source)
at
org.apache.ojb.broker.accesslayer.StatementManager.bindStatementValue(Unknow
n Source)
at org.apache.ojb.broker.accesslayer.StatementManager.bindStatement(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.StatementManager.bindSelectionCriteria(Unk
nown Source)
at org.apache.ojb.broker.accesslayer.StatementManager.bindStatement(Unknown
Source)
at org.apache.ojb.broker.accesslayer.StatementManager.bindStatement(Unknown
Source)
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(Unknown
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unkn
own Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Unkn
own Source)
at
com.alloy.common.business.AccountManagement.retrieveAccountByUsername(Accoun
tManagement.java:115)
at test.AccountTest.main(AccountTest.java:17)
org.apache.ojb.broker.PersistenceBrokerException:
org.apache.ojb.broker.PersistenceBrokerSQLException: java.sql.SQLException:
Not supported type with setObject:2,java.lang.String,4
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Unkn
own Source)
at
com.alloy.common.business.AccountManagement.retrieveAccountByUsername(Accoun
tManagement.java:115)
at test.AccountTest.main(AccountTest.java:17)
Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException:
java.sql.SQLException: Not supported type with
setObject:2,java.lang.String,4
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(Unknown
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unkn
own Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
... 7 more
Caused by: java.sql.SQLException: Not supported type with
setObject:2,java.lang.String,4
at com.inet.tds.c.setObject(Unknown Source)
at com.inet.tds.c.setObject(Unknown Source)
at
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Un
known Source)
at
org.apache.ojb.broker.accesslayer.StatementManager.bindStatementValue(Unknow
n Source)
at org.apache.ojb.broker.accesslayer.StatementManager.bindStatement(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.StatementManager.bindSelectionCriteria(Unk
nown Source)
at org.apache.ojb.broker.accesslayer.StatementManager.bindStatement(Unknown
Source)
at org.apache.ojb.broker.accesslayer.StatementManager.bindStatement(Unknown
Source)
... 13 more
Any Idea .. ?????
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
