Hi All,
I have a question not resolved these days, I do not know why the JDBC Driver
of mssqlserver4 of BEA doesn’t absolute support JDBC 2.0 Specification of
SUN, however, the sample of Persisting Behavioral Tracking Data gave by BEA used
JDBC 2.0 Method, When I test myself or Portal4.0 sample, it always display error
as following:
<Error> <Tracking> <Error persisting event to database.
java.sql.SQLException: java.sql.SQLException: This JDBC 2.0 method is not implemented
at weblogic.jdbc.rmi.SerialPreparedStatement.setCharacterStream(SerialPreparedStatement.java:428)
at com.bea.p13n.util.jdbc.JdbcHelper._setClob(JdbcHelper.java:424)
at com.bea.p13n.util.jdbc.JdbcHelper.setClob(JdbcHelper.java:404)
at com.bea.p13n.tracking.internal.persistence.BehaviorTrackingPersister.setPreparedStatementData(BehaviorTrackingPersister.java:93)
at com.bea.p13n.tracking.internal.persistence.AbstractDatabasePersister.persist(AbstractDatabasePersister.java:157)
at com.bea.p13n.tracking.internal.persistence.BufferManager$PersistenceRequest.execute(BufferManager.java:250)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
>
At first I think my configuration has problem, so I write a program to test JDBC
Driver, as a result I am sure the JDBC Driver of BEA has problem, I think the
reason is maybe the license need to be paid, so it doesn’t let me use JDBC
2.0 Method . :-)
I used another way to resolve this problem, I downloaded a time limited JDBC Driver(http://www.j-netdirect.com/DownloadSoftware.htm),
it can support JDBC 2.0 Specification of SUN , now I configured in the Weblogic,
it works smoothly.
Best Regards,
WangSong