I tried the example and if failed. I am running MySQL (on Win2000) and I
commented out
the clob stuff because MySQL does not support that but it does have a
blob type.
Still I got the following error, saying Unknown Types value.
Does that mean MySQL is not supported with OJB framework
(I pasted my class-descriptor) or am I doing something else wrong?
Thanks
D:\Java\jdk_1.4.0\bin\javaw.exe -classpath
D:\Java\jdk_1.4.0\jre\lib\rt.jar;D:\Java\jdk_1.4.0\jre\lib\ext\dnsns.jar;D:\Java\jdk_1.4.0\jre\lib\ext\ldapsec.jar;D:\Java\jdk_1.4.0\jre\lib\ext\localedata.jar;D:\Java\jdk_1.4.0\jre\lib\ext\sunjce_provider.jar;D:\jakarta-tomcat-4.0.4\webapps\gk\WEB-INF\classes;D:\jakarta-tomcat-3.3.1\lib\common\servlet.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\activation.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\ant.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\antlr.debug.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\antlr.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\antlr_compiletime.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\castor-0.9.3.19.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\commons-beanutils.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\commons-collections-2.0.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\commons-lang-0.1-dev.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\commons-logging.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\commons-pool.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\cos.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\crossdb.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\csv.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\ejb.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\hsqldb.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\jakarta-ojb-0.9.4.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\jakarta-regexp-1.2.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\jboss-common.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\jboss-system.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\jca1.0.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\jdbc2_0-stdext.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\jdo.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\jdom.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\jmxri.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\jndi.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\jta-spec1_0_1.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\junit.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\log4j-1.2.5.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\log4j-1.2.6.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\mail.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\multipart.zip;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\mysql-connector-java-2.0.14-bin.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\optional.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\p6spy.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\proxy.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\servlet.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\struts.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\torque-3.0-b3-dev.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\velocity-1.3-dev.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\xalan.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\xerces.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\xercesImpl.jar;D:\jakarta-tomcat-3.3.1\webapps\gk\WEB-INF\lib\xml-apis.jar
org.apache.ojb.broker.BlobTest
.[BOOT] INFO: OJB.properties:
file:/D:/jakarta-tomcat-4.0.4/webapps/gk/WEB-INF/classes/OJB.properties
[org.apache.ojb.broker.accesslayer.JdbcAccess] ERROR: SQLException
during the execution of the insert: Unknown Types value
Unknown Types value
java.sql.SQLException: Unknown Types value
at com.mysql.jdbc.PreparedStatement.setObject(Unknown Source)
at com.mysql.jdbc.PreparedStatement.setObject(Unknown Source)
at
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Unknown
Source)
at
org.apache.ojb.broker.platforms.PlatformMySQLImpl.setObjectForStatement(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.StatementManager.bindInsert(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.JdbcAccess.executeInsert(Unknown Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown Source)
at org.apache.ojb.broker.BlobTest.testBlobInsertion(BlobTest.java:84)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at junit.framework.TestCase.runTest(TestCase.java:166)
at junit.framework.TestCase.runBare(TestCase.java:140)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:131)
at junit.framework.TestSuite.runTest(TestSuite.java:173)
at junit.framework.TestSuite.run(TestSuite.java:168)
at junit.textui.TestRunner.doRun(TestRunner.java:74)
at junit.textui.TestRunner.start(TestRunner.java:234)
at junit.textui.TestRunner.main(TestRunner.java:112)
at org.apache.ojb.broker.BlobTest.main(BlobTest.java:32)
[DEFAULT] ERROR: null
org.apache.ojb.broker.PersistenceBrokerSQLException
at
org.apache.ojb.broker.accesslayer.JdbcAccess.executeInsert(Unknown Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown Source)
at org.apache.ojb.broker.BlobTest.testBlobInsertion(BlobTest.java:84)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at junit.framework.TestCase.runTest(TestCase.java:166)
at junit.framework.TestCase.runBare(TestCase.java:140)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:131)
at junit.framework.TestSuite.runTest(TestSuite.java:173)
at junit.framework.TestSuite.run(TestSuite.java:168)
at junit.textui.TestRunner.doRun(TestRunner.java:74)
at junit.textui.TestRunner.start(TestRunner.java:234)
at junit.textui.TestRunner.main(TestRunner.java:112)
at org.apache.ojb.broker.BlobTest.main(BlobTest.java:32)
Caused by: java.sql.SQLException: Unknown Types value
at com.mysql.jdbc.PreparedStatement.setObject(Unknown Source)
at com.mysql.jdbc.PreparedStatement.setObject(Unknown Source)
at
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Unknown
Source)
at
org.apache.ojb.broker.platforms.PlatformMySQLImpl.setObjectForStatement(Unknown
Source)
at org.apache.ojb.broker.accessla
<class-descriptor
class="org.apache.ojb.broker.ObjectWithBlob"
table="test"
>
<field-descriptor id="1"
name="id"
column="id"
primarykey="true"
jdbc-type="INTEGER"
/>
<field-descriptor id="2"
name="blob"
column="bl"
jdbc-type="BLOB"
/>
</class-descriptor>
Thomas Mahler wrote:
> byte[]
>
> see
> http://jakarta.apache.org/ojb/xref/org/apache/ojb/broker/BlobTest.html
> http://jakarta.apache.org/ojb/xref/org/apache/ojb/broker/ObjectWithBlob.html
>
>
> cheers,
> Thomas
>
> Christian Pich wrote:
>
>> How do I get an image contents into the database?
>> The db has a blob column but what object do
>> I use in JAva to set the blob contents (
>> and retrieve), the image itself?
>> java.sql.Blob is only an abstract class
>> and not meant to set blob-content.
>>
>>
>>
>> --
>> To unsubscribe, e-mail:
>> <mailto:[EMAIL PROTECTED]>
>> For additional commands, e-mail:
>> <mailto:[EMAIL PROTECTED]>
>>
>>
>>
>>
>
>
>
> --
> To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
