Re: Oracle config

[Bill Leng]

Hi,

I have a different problem and hope someone can help. I use Torque on 
Oracle 8i. The table has a column with the type BLOB. When I try to 
insert through the Peer class, I got an exception (see below).

rethrown as org.apache.torque.TorqueException: ORA-01461: can bind a 
LONG valu
only for insert into a LONG column
        at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:729)
        at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:615)
        at torque.BaseDbTypesPeer.doInsert(BaseDbTypesPeer.java:217)
        at torque.BaseDbTypesPeer.doInsert(BaseDbTypesPeer.java:575)
        at torque.BaseDbTypes.save(BaseDbTypes.java:456)
        at TorqueTest.test_BLOB_Type(TorqueTest.java:576)
        at java.lang.reflect.Method.invoke(Native Method)

thanks

Bill Leng
Metatomix, Inc.
Ramesh Sabeti wrote:

Here's a working Oracle setup:

torque.database.default=default
torque.database.default.adapter=oracle 

torque.dsfactory.default.connection.driver =
oracle.jdbc.driver.OracleDriver 
torque.dsfactory.default.connection.url =
jdbc:oracle:thin:@servername:1521:dbname
torque.dsfactory.default.connection.user = USERNAME 
torque.dsfactory.default.connection.password = password

torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataS
ourceFactory
torque.dsfactory.default.pool.defaultMaxConnections=10
torque.dsfactory.default.pool.maxExpiryTime=3600
torque.dsfactory.default.pool.connectionWaitTimeout=10
torque.database.logInterval=0

Of course, you need to replace servername, dbname, username, and
password with correct properties.
Good luck,

Ramesh.




-----Original Message-----
From: Irazabal, Alex [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 11:36 AM
To: '[EMAIL PROTECTED]'
Subject: Oracle config
I have looked thru the archives for a valid configuration file for

Oracle.

Here is what I have and it doesn't seem to work...


torque.dsfactory.CPMSDEV.factory=org.apache.torque.dsfactory.TorqueDataS
ou
rc
eFactory
torque.dsfactory.CPMSDEV.pool.defaultMaxConnections=10

torque.dsfactory.CPMSDEV.pool.maxExpiryTime=3600

torque.dsfactory.CPMSDEV.pool.connectionWaitTimeout=10

torque.dsfactory.CPMSDEV.connection.driver =
oracle.jdbc.driver.OracleDriver
torque.dsfactory.CPMSDEV.connection.url =
jdbc:oracle:thin://ETA:1521:CPMSDEV
torque.dsfactory.CPMSDEV.connection.user = CPMS_CLAIM_OWNER

torque.dsfactory.CPMSDEV.connection.password = CPMS_CLAIM_OWNER



And here is the error I get when I run my test:

235 [main] ERROR dsfactory.AbstractDataSourceFactory - Property:

driver

value: oracle.jdbc.driver.OracleDriver is not supported by DataSource:
org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS
235 [main] ERROR dsfactory.TorqueDataSourceFactory -

java.lang.reflect.InvocationTargetException

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at


sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:
39
)
at


sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Im
pl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)

at


org.apache.commons.beanutils.PropertyUtils.setSimpleProperty(PropertyUti
ls
.j
ava:1650)
at


org.apache.torque.dsfactory.AbstractDataSourceFactory.setProperty(Abstra
ct
Da
taSourceFactory.java:121)
at


org.apache.torque.dsfactory.TorqueDataSourceFactory.initCPDS(TorqueDataS
ou
rc
eFactory.java:134)
at


org.apache.torque.dsfactory.TorqueDataSourceFactory.initialize(TorqueDat
aS
ou
rceFactory.java:108)
at org.apache.torque.Torque.initDataSourceFactories(Torque.java:323)

at org.apache.torque.Torque.initialize(Torque.java:237)

at org.apache.torque.Torque.init(Torque.java:406)

at org.apache.torque.Torque.init(Torque.java:386)

at com.ai.torque.om.cpmsdevTest.main(cpmsdevTest.java:14)

Caused by: java.lang.ClassNotFoundException:
oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:198)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(URLClassLoader.java:186)

at java.lang.ClassLoader.loadClass(ClassLoader.java:299)

at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265)

at java.lang.ClassLoader.loadClass(ClassLoader.java:255)

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:140)

at


org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.setDriver(DriverAd
ap
te
rCPDS.java:441)
... 13 more

266 [main] ERROR torque.Torque -



Any ideas?



Alex Irazabal
AIGM Distributed Apps
3 Beaver Valley Road
Wilmington DE-19803
* (302)-252-4783




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