Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » java.sql.Statement has been closed strangely when inner joining 2 datasets
java.sql.Statement has been closed strangely when inner joining 2 datasets [message #553357] Tue, 17 August 2010 09:17 Go to next message
Ricky  is currently offline Ricky Friend
Messages: 9
Registered: June 2010
Junior Member
Hi friends,

Our company uses DataDirect drivers for accessing most of the popular databases. We also integrated those drivers into birt designer. We created a plugin extending org.eclipse.birt.report.data.oda.jdbc.driverinfo.

But I met a curious issue which I think it may be due to the datadirect driver. because I could not recreate the issue with database-provided driver.

Here are the steps to recreate the issue:
1.Create a birt report with two datasources(using datadirect driver) which must point to different database with the same type. That means use the same driver. You can use either two Oracle databases or two DB2 databases or two SQLSERVER databases.
Datasource1:
rkyoem.jdbc.oracle.OracleDriver (Data Direct Driver for Oracle)
jdbc:rkyoem:oracle://machine1:1521;SID=TEST
scott/tiger
Datasource2:
rkyoem.jdbc.oracle.OracleDriver (Data Direct Driver for Oracle)
jdbc:rkyoem:oracle://machine1:1521;SID=ORCL
scott/tiger
2.Create two datasets based on the above datasources.
DataSet1
SQL: SELECT 'AAA' AS TEST FROM DEPT.(preview successfully. This sql can return 4 rows with the same value 'AAA').
DataSet2
SQL: SELECT 'AAA' AS ORCL FROM DEPT.(preview successfully. This sql can return 4 rows with the same value 'AAA').
3.Create a Joint Data Set(inner join) with the above datasets. join them by their columns TEST AND ORCL.
4.Click the "preview results" in the dataset wizard page. You will get the follow error:
!ENTRY org.eclipse.birt.data 4 1001 2010-08-17 16:54:14.723
!MESSAGE A BIRT exception occurred.
!STACK 0
org.eclipse.birt.data.engine.core.DataException: Cannot execute the statement.
SQL statement does not return a ResultSet object.
SQL error #1: [RKYOEM][Oracle JDBC Driver]Object has been closed.

at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.e xecute(PreparedStatement.java:559)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.execut e(DataSourceQuery.java:670)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:331)
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(Quer yExecutor.java:904)
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.exe cuteQuery(ServiceForQueryResults.java:233)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIter ator(QueryResults.java:161)
at org.eclipse.birt.data.engine.impl.PreparedJointDataSourceQue ry$JointDataSetQueryExecutor.executeOdiQuery(PreparedJointDa taSourceQuery.java:629)
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(Quer yExecutor.java:904)
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.exe cuteQuery(ServiceForQueryResults.java:233)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIter ator(QueryResults.java:161)
at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr eviewPage.populateRecords(ResultSetPreviewPage.java:549)
at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr eviewPage.access$3(ResultSetPreviewPage.java:543)
at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr eviewPage$5.run(ResultSetPreviewPage.java:463)
at org.eclipse.jface.operation.ModalContext$ModalContextThread. run(ModalContext.java:121)
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1: [RKYOEM][Oracle JDBC Driver]Object has been closed.
;
java.sql.SQLException: [RKYOEM][Oracle JDBC Driver]Object has been closed.
at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:445)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doExecuteQuery(OdaQuery.java:443)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.executeQuery(OdaQuery.java:408)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.e xecute(PreparedStatement.java:545)
... 13 more
Caused by: java.sql.SQLException: [RKYOEM][Oracle JDBC Driver]Object has been closed.
at rkyoem.jdbc.oraclebase.BaseExceptions.createSQLException(Unk nown Source)
at rkyoem.jdbc.oraclebase.BaseExceptions.createException(Unknow n Source)
at rkyoem.jdbc.oraclebase.BaseExceptions.getException(Unknown Source)
at rkyoem.jdbc.oraclebase.BasePreparedStatement.executeQuery(Un known Source)
at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:441)
... 16 more
!SUBENTRY 1 org.eclipse.birt.data 1 1001 2010-08-17 16:54:14.723
!MESSAGE Plug-in Provider:Eclipse.org
!SUBENTRY 1 org.eclipse.birt.data 1 1001 2010-08-17 16:54:14.723
!MESSAGE Plug-in Name:BIRT Data Engine
!SUBENTRY 1 org.eclipse.birt.data 1 1001 2010-08-17 16:54:14.723
!MESSAGE Plug-in ID:org.eclipse.birt.data
!SUBENTRY 1 org.eclipse.birt.data 1 1001 2010-08-17 16:54:14.723
!MESSAGE Version:2.3.1.v20080829
!SUBENTRY 1 org.eclipse.birt.data 4 1001 2010-08-17 16:54:14.723
!MESSAGE Error Code:odaconsumer.CannotExecuteStatement
!SUBENTRY 1 org.eclipse.birt.data 4 1001 2010-08-17 16:54:14.723
!MESSAGE Error Message:Cannot execute the statement.
SQL statement does not return a ResultSet object.
SQL error #1: [RKYOEM][Oracle JDBC Driver]Object has been closed.

I downloaded birt source to debug where the error is. But in the debug envioroment, I get the same error(object has been closed) if I try to previewing any dataset. Even for a simple dataset, I get the follow error even I use the database-provided driver:

java.sql.SQLException: Closed Statement
at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:445)
at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaUsing DefaultPolicy(Statement.java:352)
at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData( Statement.java:294)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doGetMetaData(OdaQuery.java:388)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.getMetaData(OdaQuery.java:356)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etRuntimeMetaData(PreparedStatement.java:365)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etProjectedColumns(PreparedStatement.java:335)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.d oGetMetaData(PreparedStatement.java:305)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.e xecute(PreparedStatement.java:533)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.execut e(DataSourceQuery.java:670)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:331)
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(Quer yExecutor.java:904)
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.exe cuteQuery(ServiceForQueryResults.java:233)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIter ator(QueryResults.java:161)
at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr eviewPage.populateRecords(ResultSetPreviewPage.java:549)
at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr eviewPage.access$3(ResultSetPreviewPage.java:543)
at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr eviewPage$5.run(ResultSetPreviewPage.java:463)
at org.eclipse.jface.operation.ModalContext$ModalContextThread. run(ModalContext.java:121)
Caused by: java.sql.SQLException: Closed Statement
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateM apping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseErr or.java:110)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseE rror.java:171)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseE rror.java:227)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseE rror.java:439)
at oracle.jdbc.driver.OracleClosedStatement.executeQuery(Oracle ClosedStatement.java:2282)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQue ry(OraclePreparedStatementWrapper.java:1202)
at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:441)
... 17 more


I do not know the reason. From the stack, I believe it is not plugin's problem. So, I am not able to find the issue by debuging birt. Does anyone have suggestion on it? Any feedback is welcome !

[Updated on: Tue, 17 August 2010 09:22]

Report message to a moderator

Re: java.sql.Statement has been closed strangely when inner joining 2 datasets [message #553535 is a reply to message #553357] Tue, 17 August 2010 20:22 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Ricky,

My first guess is a problem with the driverinfo extension
implementation. It may be a good idea to open a bug for this. As a
test can you add the following to the beforeFactory script of the report:

reportContext.getAppContext().put("OdaJDBCDriverPassInConnectionCloseAfterUse ",
false);

Jason


On 8/17/2010 5:17 AM, Ricky wrote:
> Hi friends,
>
> Our company uses DataDirect drivers for accessing most of the popular
> databases. We also integrated those drivers into birt designer. We
> created a plugin extending
> org.eclipse.birt.report.data.oda.jdbc.driverinfo.
> But I met a curious issue which I think it may be due to the datadirect
> driver. because I could not recreate the issue with database-provided
> driver.
>
> Here are the steps to recreate the issue:
> 1.Create a birt report with two datasources(using datadirect driver)
> which must point to different database with the same type. That means
> use the same driver. You can use either two Oracle databases or two DB2
> databases or two SQLSERVER databases.
> Datasource1:
> rkyoem.jdbc.oracle.OracleDriver (Data Direct Driver for Oracle)
> jdbc:rkyoem:oracle://machine1:1521;SID=TEST
> scott/tiger
> Datasource2:
> rkyoem.jdbc.oracle.OracleDriver (Data Direct Driver for Oracle)
> jdbc:rkyoem:oracle://machine1:1521;SID=ORCL
> scott/tiger
> 2.Create two datasets based on the above datasources.
> DataSet1
> SQL: SELECT 'AAA' AS TEST FROM DEPT.(preview successfully. This sql can
> return 4 rows with the same value 'AAA').
> DataSet2
> SQL: SELECT 'AAA' AS ORCL FROM DEPT.(preview successfully. This sql can
> return 4 rows with the same value 'AAA').
> 3.Create a Joint Data Set(inner join) with the above datasets. join them
> by their columns TEST AND ORCL.
> 4.Click the "preview results" in the dataset wizard page. You will get
> the follow error:
> !ENTRY org.eclipse.birt.data 4 1001 2010-08-17 16:54:14.723
> !MESSAGE A BIRT exception occurred.
> !STACK 0
> org.eclipse.birt.data.engine.core.DataException: Cannot execute the
> statement.
> SQL statement does not return a ResultSet object.
> SQL error #1: [RKYOEM][Oracle JDBC Driver]Object has been closed.
>
> at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.e
> xecute(PreparedStatement.java:559)
> at org.eclipse.birt.data.engine.executor.DataSourceQuery.execut
> e(DataSourceQuery.java:670)
> at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu
> eryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:331)
> at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(Quer
> yExecutor.java:904)
> at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.exe
> cuteQuery(ServiceForQueryResults.java:233)
> at org.eclipse.birt.data.engine.impl.QueryResults.getResultIter
> ator(QueryResults.java:161)
> at org.eclipse.birt.data.engine.impl.PreparedJointDataSourceQue
> ry$JointDataSetQueryExecutor.executeOdiQuery(PreparedJointDa
> taSourceQuery.java:629)
> at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(Quer
> yExecutor.java:904)
> at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.exe
> cuteQuery(ServiceForQueryResults.java:233)
> at org.eclipse.birt.data.engine.impl.QueryResults.getResultIter
> ator(QueryResults.java:161)
> at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr
> eviewPage.populateRecords(ResultSetPreviewPage.java:549)
> at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr
> eviewPage.access$3(ResultSetPreviewPage.java:543)
> at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr
> eviewPage$5.run(ResultSetPreviewPage.java:463)
> at org.eclipse.jface.operation.ModalContext$ModalContextThread.
> run(ModalContext.java:121)
> Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL
> statement does not return a ResultSet object.
> SQL error #1: [RKYOEM][Oracle JDBC Driver]Object has been closed.
> ;
> java.sql.SQLException: [RKYOEM][Oracle JDBC Driver]Object has been closed.
> at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery
> (Statement.java:445)
> at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu
> ery.doExecuteQuery(OdaQuery.java:443)
> at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu
> ery.executeQuery(OdaQuery.java:408)
> at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.e
> xecute(PreparedStatement.java:545)
> ... 13 more
> Caused by: java.sql.SQLException: [RKYOEM][Oracle JDBC Driver]Object has
> been closed.
> at rkyoem.jdbc.oraclebase.BaseExceptions.createSQLException(Unk nown
> Source)
> at rkyoem.jdbc.oraclebase.BaseExceptions.createException(Unknow n Source)
> at rkyoem.jdbc.oraclebase.BaseExceptions.getException(Unknown Source)
> at rkyoem.jdbc.oraclebase.BasePreparedStatement.executeQuery(Un known
> Source)
> at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery
> (Statement.java:441)
> ... 16 more
> !SUBENTRY 1 org.eclipse.birt.data 1 1001 2010-08-17 16:54:14.723
> !MESSAGE Plug-in Provider:Eclipse.org
> !SUBENTRY 1 org.eclipse.birt.data 1 1001 2010-08-17 16:54:14.723
> !MESSAGE Plug-in Name:BIRT Data Engine
> !SUBENTRY 1 org.eclipse.birt.data 1 1001 2010-08-17 16:54:14.723
> !MESSAGE Plug-in ID:org.eclipse.birt.data
> !SUBENTRY 1 org.eclipse.birt.data 1 1001 2010-08-17 16:54:14.723
> !MESSAGE Version:2.3.1.v20080829
> !SUBENTRY 1 org.eclipse.birt.data 4 1001 2010-08-17 16:54:14.723
> !MESSAGE Error Code:odaconsumer.CannotExecuteStatement
> !SUBENTRY 1 org.eclipse.birt.data 4 1001 2010-08-17 16:54:14.723
> !MESSAGE Error Message:Cannot execute the statement.
> SQL statement does not return a ResultSet object.
> SQL error #1: [RKYOEM][Oracle JDBC Driver]Object has been closed.
>
> I downloaded birt source to debug where the error is. But in the debug
> envioroment, I get the same error(object has been closed) if I try to
> previewing any dataset. Even for a simple dataset, I get the follow
> error even I use the database-provided driver:
> java.sql.SQLException: Closed Statement
> at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery
> (Statement.java:445)
> at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaUsing
> DefaultPolicy(Statement.java:352)
> at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData(
> Statement.java:294)
> at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu
> ery.doGetMetaData(OdaQuery.java:388)
> at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu
> ery.getMetaData(OdaQuery.java:356)
> at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g
> etRuntimeMetaData(PreparedStatement.java:365)
> at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g
> etProjectedColumns(PreparedStatement.java:335)
> at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.d
> oGetMetaData(PreparedStatement.java:305)
> at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.e
> xecute(PreparedStatement.java:533)
> at org.eclipse.birt.data.engine.executor.DataSourceQuery.execut
> e(DataSourceQuery.java:670)
> at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu
> eryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:331)
> at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(Quer
> yExecutor.java:904)
> at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.exe
> cuteQuery(ServiceForQueryResults.java:233)
> at org.eclipse.birt.data.engine.impl.QueryResults.getResultIter
> ator(QueryResults.java:161)
> at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr
> eviewPage.populateRecords(ResultSetPreviewPage.java:549)
> at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr
> eviewPage.access$3(ResultSetPreviewPage.java:543)
> at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPr
> eviewPage$5.run(ResultSetPreviewPage.java:463)
> at org.eclipse.jface.operation.ModalContext$ModalContextThread.
> run(ModalContext.java:121)
> Caused by: java.sql.SQLException: Closed Statement
> at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateM
> apping.java:70)
> at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseErr
> or.java:110)
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseE
> rror.java:171)
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseE
> rror.java:227)
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseE
> rror.java:439)
> at oracle.jdbc.driver.OracleClosedStatement.executeQuery(Oracle
> ClosedStatement.java:2282)
> at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQue
> ry(OraclePreparedStatementWrapper.java:1202)
> at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery
> (Statement.java:441)
> ... 17 more
> I do not know the reason. From the stack, I believe it is not plugin's
> problem. So, I am not able to find the issue by debuging birt. Does
> anyone have suggestion on it? Any feedback is welcome !
>
Re: java.sql.Statement has been closed strangely when inner joining 2 datasets [message #553560 is a reply to message #553535] Wed, 18 August 2010 02:53 Go to previous messageGo to next message
Ricky  is currently offline Ricky Friend
Messages: 9
Registered: June 2010
Junior Member
Hi Jason,

Thanks for your reply.
I added the setting in the beforeFactory script but I still got the same error.

-Ricky
Re: java.sql.Statement has been closed strangely when inner joining 2 datasets [message #553563 is a reply to message #553560] Wed, 18 August 2010 03:37 Go to previous messageGo to next message
Ricky  is currently offline Ricky Friend
Messages: 9
Registered: June 2010
Junior Member
I also turned on the DataDirect Spy Logging to troubleshoot birt. I saw the error from the ui. But I could not see any exception in the spy log pasted below:

spy>> Connection[15].isClosed()
spy>> OK (false)

spy>> Connection[15].close()
spy>> OK

spy>> Connection[16].getMetaData()
spy>> OK (DatabaseMetaData[73])

spy>> DatabaseMetaData[73].getURL()
spy>> OK (jdbc:rkyoem:oracle://machine1:1521 ;CATALOGOPTIONS=2;CONNECTIONRETRYDELAY=1;BULKLOADBATCHSIZE=1 000;SUPPORTLINKS=false;MAXPOOLEDSTATEMENTS=0;SPYATTRIBUTES=( log=(file)c:\temp\spy_rky.log);KEYSTORE=;NEWPASSWORD=;STRING PARAMSMUSTMATCHCHARCOLUMNS=true;PROGRAMID=;ENABLECANCELTIMEO UT=false;TRUSTSTOREPASSWORD=;VALIDATESERVERCERTIFICATE=true; CODEPAGEOVERRIDE=;REFCURSORSUPPORT=true;KEYSTOREPASSWORD=;CO NNECTIONRETRYCOUNT=5;SENDFLOATPARAMETERSASSTRING=false;COMMI TBEHAVIOR=serverDefault;ENABLEBULKLOAD=false;TNSSERVERNAME=; BATCHPERFORMANCEWORKAROUND=false;INITIALIZATIONSTRING=;FAILO VERPRECONNECT=false;ENABLESERVERRESULTCACHE=false;RESULTSETM ETADATAOPTIONS=0;CLIENTUSER=;QUERYTIMEOUT=0;HOSTNAMEINCERTIF ICATE=;FAILOVERGRANULARITY=nonAtomic;WIREPROTOCOLMODE=1;CATA LOGINCLUDESSYNONYMS=true;APPLICATIONNAME=;JAVADOUBLETOSTRING =false;LOADLIBRARYPATH=;INITIALCOLUMNBUFFERSIZE=-1;IMPORTSTA TEMENTPOOL=;ALTERNATESERVERS=;SDUSIZE=;KEYPASSWORD=;ENCRYPTI ONMETHOD=NoEncryption;ACCOUNTINGINFO=;CONVERTNULL=1;TRUSTSTO RE=;TNSNAMESFILE=;JDBCBEHAVIOR=1;FAILOVERMODE=connect;AUTHEN TICATIONMETHOD=auto;LOGINTIMEOUT=0;SERVICENAME=;SERVERTYPE=; LOADBALANCING=false;SID=ORCL;WORKAROUNDS=0;INSENSITIVERESULT SETBUFFERSIZE=2048;SYSLOGINROLE=;CLIENTHOSTNAME=;FETCHTSWTZA STIMESTAMP=false)

spy>> DatabaseMetaData[73].getDriverName()
spy>> OK (Oracle)

spy>> DatabaseMetaData[73].getDriverVersion()
spy>> OK (4.0.027033 (040328.014805))

spy>> DatabaseMetaData[73].getDatabaseProductName()
spy>> OK (Oracle)

spy>> DatabaseMetaData[73].getDatabaseProductVersion()
spy>> OK (11.1.0.6.0)

spy>> Connection Options :
spy>> CATALOGOPTIONS=2
spy>> CONNECTIONRETRYDELAY=1
spy>> BULKLOADBATCHSIZE=1000
spy>> SUPPORTLINKS=false
spy>> MAXPOOLEDSTATEMENTS=0
spy>> SPYATTRIBUTES=(log=(file)c:\temp\spy_rky.log)
spy>> KEYSTORE=
spy>> NEWPASSWORD=
spy>> STRINGPARAMSMUSTMATCHCHARCOLUMNS=true
spy>> PROGRAMID=
spy>> ENABLECANCELTIMEOUT=false
spy>> TRUSTSTOREPASSWORD=
spy>> VALIDATESERVERCERTIFICATE=true
spy>> CODEPAGEOVERRIDE=
spy>> REFCURSORSUPPORT=true
spy>> KEYSTOREPASSWORD=
spy>> CONNECTIONRETRYCOUNT=5
spy>> SENDFLOATPARAMETERSASSTRING=false
spy>> COMMITBEHAVIOR=serverDefault
spy>> ENABLEBULKLOAD=false
spy>> TNSSERVERNAME=
spy>> BATCHPERFORMANCEWORKAROUND=false
spy>> INITIALIZATIONSTRING=
spy>> FAILOVERPRECONNECT=false
spy>> ENABLESERVERRESULTCACHE=false
spy>> RESULTSETMETADATAOPTIONS=0
spy>> CLIENTUSER=
spy>> QUERYTIMEOUT=0
spy>> HOSTNAMEINCERTIFICATE=
spy>> FAILOVERGRANULARITY=nonAtomic
spy>> WIREPROTOCOLMODE=1
spy>> CATALOGINCLUDESSYNONYMS=true
spy>> APPLICATIONNAME=
spy>> JAVADOUBLETOSTRING=false
spy>> LOADLIBRARYPATH=
spy>> INITIALCOLUMNBUFFERSIZE=-1
spy>> IMPORTSTATEMENTPOOL=
spy>> ALTERNATESERVERS=
spy>> SDUSIZE=
spy>> KEYPASSWORD=
spy>> ENCRYPTIONMETHOD=NoEncryption
spy>> ACCOUNTINGINFO=
spy>> CONVERTNULL=1
spy>> TRUSTSTORE=
spy>> TNSNAMESFILE=
spy>> JDBCBEHAVIOR=1
spy>> FAILOVERMODE=connect
spy>> AUTHENTICATIONMETHOD=auto
spy>> LOGINTIMEOUT=0
spy>> SERVICENAME=
spy>> SERVERTYPE=
spy>> LOADBALANCING=false
spy>> SID=ORCL
spy>> WORKAROUNDS=0
spy>> INSENSITIVERESULTSETBUFFERSIZE=2048
spy>> SYSLOGINROLE=
spy>> CLIENTHOSTNAME=
spy>> FETCHTSWTZASTIMESTAMP=false
spy>> Driver Name = Oracle
spy>> Driver Version = 4.0.027033 (040328.014805)
spy>> Database Name = Oracle
spy>> Database Version = 11.1.0.6.0

spy>> Connection[16].getMetaData()
spy>> OK (DatabaseMetaData[74])

spy>> DatabaseMetaData[74].getMaxStatements()
spy>> OK (0)

spy>> Connection[16].getMetaData()
spy>> OK (DatabaseMetaData[75])

spy>> DatabaseMetaData[75].getMaxStatements()
spy>> OK (0)

spy>> Connection[16].getMetaData()
spy>> OK (DatabaseMetaData[76])

spy>> DatabaseMetaData[76].getMaxStatements()
spy>> OK (0)

spy>> Connection[16].prepareStatement(String sql)
spy>> sql = select 'AAA' AS ORCL
from DEPT
spy>> OK (PreparedStatement[15])

spy>> PreparedStatement[15].getConnection()
spy>> OK (Connection[16])

spy>> Connection[16].getMetaData()
spy>> OK (DatabaseMetaData[77])

spy>> DatabaseMetaData[77].getDriverName()
spy>> OK (Oracle)

spy>> PreparedStatement[15].getMetaData()
spy>> OK (ResultSetMetaData[14])

spy>> ResultSetMetaData[14].getColumnCount()
spy>> OK (1)

spy>> ResultSetMetaData[14].getColumnCount()
spy>> OK (1)

spy>> ResultSetMetaData[14].getColumnCount()
spy>> OK (1)

spy>> ResultSetMetaData[14].getColumnName(int column)
spy>> column = 1
spy>> OK (ORCL)

spy>> ResultSetMetaData[14].getColumnLabel(int column)
spy>> column = 1
spy>> OK (ORCL)

spy>> ResultSetMetaData[14].getColumnClassName(int column)
spy>> column = 1
spy>> OK (java.lang.String)

spy>> ResultSetMetaData[14].getColumnClassName(int column)
spy>> column = 1
spy>> OK (java.lang.String)

spy>> ResultSetMetaData[14].getColumnTypeName(int column)
spy>> column = 1
spy>> OK (char)

spy>> Connection[16].isClosed()
spy>> OK (false)

spy>> Connection[16].close()
spy>> OK

spy>> Connection[17].getMetaData()
spy>> OK (DatabaseMetaData[78])

spy>> DatabaseMetaData[78].getURL()
spy>> OK (jdbc:rkyoem:oracle://machine1:1521 ;CATALOGOPTIONS=2;CONNECTIONRETRYDELAY=1;BULKLOADBATCHSIZE=1 000;SUPPORTLINKS=false;MAXPOOLEDSTATEMENTS=0;SPYATTRIBUTES=( log=(file)c:\temp\spy_rky.log);KEYSTORE=;NEWPASSWORD=;STRING PARAMSMUSTMATCHCHARCOLUMNS=true;PROGRAMID=;ENABLECANCELTIMEO UT=false;TRUSTSTOREPASSWORD=;VALIDATESERVERCERTIFICATE=true; CODEPAGEOVERRIDE=;REFCURSORSUPPORT=true;KEYSTOREPASSWORD=;CO NNECTIONRETRYCOUNT=5;SENDFLOATPARAMETERSASSTRING=false;COMMI TBEHAVIOR=serverDefault;ENABLEBULKLOAD=false;TNSSERVERNAME=; BATCHPERFORMANCEWORKAROUND=false;INITIALIZATIONSTRING=;FAILO VERPRECONNECT=false;ENABLESERVERRESULTCACHE=false;RESULTSETM ETADATAOPTIONS=0;CLIENTUSER=;QUERYTIMEOUT=0;HOSTNAMEINCERTIF ICATE=;FAILOVERGRANULARITY=nonAtomic;WIREPROTOCOLMODE=1;CATA LOGINCLUDESSYNONYMS=true;APPLICATIONNAME=;JAVADOUBLETOSTRING =false;LOADLIBRARYPATH=;INITIALCOLUMNBUFFERSIZE=-1;IMPORTSTA TEMENTPOOL=;ALTERNATESERVERS=;SDUSIZE=;KEYPASSWORD=;ENCRYPTI ONMETHOD=NoEncryption;ACCOUNTINGINFO=;CONVERTNULL=1;TRUSTSTO RE=;TNSNAMESFILE=;JDBCBEHAVIOR=1;FAILOVERMODE=connect;AUTHEN TICATIONMETHOD=auto;LOGINTIMEOUT=0;SERVICENAME=;SERVERTYPE=; LOADBALANCING=false;SID=TEST;WORKAROUNDS=0;INSENSITIVERESULT SETBUFFERSIZE=2048;SYSLOGINROLE=;CLIENTHOSTNAME=;FETCHTSWTZA STIMESTAMP=false)

spy>> DatabaseMetaData[78].getDriverName()
spy>> OK (Oracle)

spy>> DatabaseMetaData[78].getDriverVersion()
spy>> OK (4.0.027033 (040328.014805))

spy>> DatabaseMetaData[78].getDatabaseProductName()
spy>> OK (Oracle)

spy>> DatabaseMetaData[78].getDatabaseProductVersion()
spy>> OK (11.1.0.6.0)

spy>> Connection Options :
spy>> CATALOGOPTIONS=2
spy>> CONNECTIONRETRYDELAY=1
spy>> BULKLOADBATCHSIZE=1000
spy>> SUPPORTLINKS=false
spy>> MAXPOOLEDSTATEMENTS=0
spy>> SPYATTRIBUTES=(log=(file)c:\temp\spy_rky.log)
spy>> KEYSTORE=
spy>> NEWPASSWORD=
spy>> STRINGPARAMSMUSTMATCHCHARCOLUMNS=true
spy>> PROGRAMID=
spy>> ENABLECANCELTIMEOUT=false
spy>> TRUSTSTOREPASSWORD=
spy>> VALIDATESERVERCERTIFICATE=true
spy>> CODEPAGEOVERRIDE=
spy>> REFCURSORSUPPORT=true
spy>> KEYSTOREPASSWORD=
spy>> CONNECTIONRETRYCOUNT=5
spy>> SENDFLOATPARAMETERSASSTRING=false
spy>> COMMITBEHAVIOR=serverDefault
spy>> ENABLEBULKLOAD=false
spy>> TNSSERVERNAME=
spy>> BATCHPERFORMANCEWORKAROUND=false
spy>> INITIALIZATIONSTRING=
spy>> FAILOVERPRECONNECT=false
spy>> ENABLESERVERRESULTCACHE=false
spy>> RESULTSETMETADATAOPTIONS=0
spy>> CLIENTUSER=
spy>> QUERYTIMEOUT=0
spy>> HOSTNAMEINCERTIFICATE=
spy>> FAILOVERGRANULARITY=nonAtomic
spy>> WIREPROTOCOLMODE=1
spy>> CATALOGINCLUDESSYNONYMS=true
spy>> APPLICATIONNAME=
spy>> JAVADOUBLETOSTRING=false
spy>> LOADLIBRARYPATH=
spy>> INITIALCOLUMNBUFFERSIZE=-1
spy>> IMPORTSTATEMENTPOOL=
spy>> ALTERNATESERVERS=
spy>> SDUSIZE=
spy>> KEYPASSWORD=
spy>> ENCRYPTIONMETHOD=NoEncryption
spy>> ACCOUNTINGINFO=
spy>> CONVERTNULL=1
spy>> TRUSTSTORE=
spy>> TNSNAMESFILE=
spy>> JDBCBEHAVIOR=1
spy>> FAILOVERMODE=connect
spy>> AUTHENTICATIONMETHOD=auto
spy>> LOGINTIMEOUT=0
spy>> SERVICENAME=
spy>> SERVERTYPE=
spy>> LOADBALANCING=false
spy>> SID=TEST
spy>> WORKAROUNDS=0
spy>> INSENSITIVERESULTSETBUFFERSIZE=2048
spy>> SYSLOGINROLE=
spy>> CLIENTHOSTNAME=
spy>> FETCHTSWTZASTIMESTAMP=false
spy>> Driver Name = Oracle
spy>> Driver Version = 4.0.027033 (040328.014805)
spy>> Database Name = Oracle
spy>> Database Version = 11.1.0.6.0

spy>> Connection[17].getMetaData()
spy>> OK (DatabaseMetaData[79])

spy>> DatabaseMetaData[79].getMaxStatements()
spy>> OK (0)

spy>> Connection[17].getMetaData()
spy>> OK (DatabaseMetaData[80])

spy>> DatabaseMetaData[80].getMaxStatements()
spy>> OK (0)

spy>> Connection[17].getMetaData()
spy>> OK (DatabaseMetaData[81])

spy>> DatabaseMetaData[81].getMaxStatements()
spy>> OK (0)

spy>> Connection[17].prepareStatement(String sql)
spy>> sql = select 'AAA' AS TEST
from EMP
spy>> OK (PreparedStatement[16])

spy>> PreparedStatement[16].getConnection()
spy>> OK (Connection[17])

spy>> Connection[17].getMetaData()
spy>> OK (DatabaseMetaData[82])

spy>> DatabaseMetaData[82].getDriverName()
spy>> OK (Oracle)

spy>> PreparedStatement[16].getMetaData()
spy>> OK (ResultSetMetaData[15])

spy>> ResultSetMetaData[15].getColumnCount()
spy>> OK (1)

spy>> ResultSetMetaData[15].getColumnCount()
spy>> OK (1)

spy>> ResultSetMetaData[15].getColumnCount()
spy>> OK (1)

spy>> ResultSetMetaData[15].getColumnName(int column)
spy>> column = 1
spy>> OK (TEST)

spy>> ResultSetMetaData[15].getColumnLabel(int column)
spy>> column = 1
spy>> OK (TEST)

spy>> ResultSetMetaData[15].getColumnClassName(int column)
spy>> column = 1
spy>> OK (java.lang.String)

spy>> ResultSetMetaData[15].getColumnClassName(int column)
spy>> column = 1
spy>> OK (java.lang.String)

spy>> ResultSetMetaData[15].getColumnTypeName(int column)
spy>> column = 1
spy>> OK (char)

spy>> PreparedStatement[16].close()
spy>> OK

spy>> Connection[17].isClosed()
spy>> OK (false)

spy>> Connection[17].close()
spy>> OK

spy>> Connection[18].getMetaData()
spy>> OK (DatabaseMetaData[83])

spy>> DatabaseMetaData[83].getURL()
spy>> OK (jdbc:rkyoem:oracle://machine1:1521 ;CATALOGOPTIONS=2;CONNECTIONRETRYDELAY=1;BULKLOADBATCHSIZE=1 000;SUPPORTLINKS=false;MAXPOOLEDSTATEMENTS=0;SPYATTRIBUTES=( log=(file)c:\temp\spy_rky.log);KEYSTORE=;NEWPASSWORD=;STRING PARAMSMUSTMATCHCHARCOLUMNS=true;PROGRAMID=;ENABLECANCELTIMEO UT=false;TRUSTSTOREPASSWORD=;VALIDATESERVERCERTIFICATE=true; CODEPAGEOVERRIDE=;REFCURSORSUPPORT=true;KEYSTOREPASSWORD=;CO NNECTIONRETRYCOUNT=5;SENDFLOATPARAMETERSASSTRING=false;COMMI TBEHAVIOR=serverDefault;ENABLEBULKLOAD=false;TNSSERVERNAME=; BATCHPERFORMANCEWORKAROUND=false;INITIALIZATIONSTRING=;FAILO VERPRECONNECT=false;ENABLESERVERRESULTCACHE=false;RESULTSETM ETADATAOPTIONS=0;CLIENTUSER=;QUERYTIMEOUT=0;HOSTNAMEINCERTIF ICATE=;FAILOVERGRANULARITY=nonAtomic;WIREPROTOCOLMODE=1;CATA LOGINCLUDESSYNONYMS=true;APPLICATIONNAME=;JAVADOUBLETOSTRING =false;LOADLIBRARYPATH=;INITIALCOLUMNBUFFERSIZE=-1;IMPORTSTA TEMENTPOOL=;ALTERNATESERVERS=;SDUSIZE=;KEYPASSWORD=;ENCRYPTI ONMETHOD=NoEncryption;ACCOUNTINGINFO=;CONVERTNULL=1;TRUSTSTO RE=;TNSNAMESFILE=;JDBCBEHAVIOR=1;FAILOVERMODE=connect;AUTHEN TICATIONMETHOD=auto;LOGINTIMEOUT=0;SERVICENAME=;SERVERTYPE=; LOADBALANCING=false;SID=ORCL;WORKAROUNDS=0;INSENSITIVERESULT SETBUFFERSIZE=2048;SYSLOGINROLE=;CLIENTHOSTNAME=;FETCHTSWTZA STIMESTAMP=false)

spy>> DatabaseMetaData[83].getDriverName()
spy>> OK (Oracle)

spy>> DatabaseMetaData[83].getDriverVersion()
spy>> OK (4.0.027033 (040328.014805))

spy>> DatabaseMetaData[83].getDatabaseProductName()
spy>> OK (Oracle)

spy>> DatabaseMetaData[83].getDatabaseProductVersion()
spy>> OK (11.1.0.6.0)

spy>> Connection Options :
spy>> CATALOGOPTIONS=2
spy>> CONNECTIONRETRYDELAY=1
spy>> BULKLOADBATCHSIZE=1000
spy>> SUPPORTLINKS=false
spy>> MAXPOOLEDSTATEMENTS=0
spy>> SPYATTRIBUTES=(log=(file)c:\temp\spy_rky.log)
spy>> KEYSTORE=
spy>> NEWPASSWORD=
spy>> STRINGPARAMSMUSTMATCHCHARCOLUMNS=true
spy>> PROGRAMID=
spy>> ENABLECANCELTIMEOUT=false
spy>> TRUSTSTOREPASSWORD=
spy>> VALIDATESERVERCERTIFICATE=true
spy>> CODEPAGEOVERRIDE=
spy>> REFCURSORSUPPORT=true
spy>> KEYSTOREPASSWORD=
spy>> CONNECTIONRETRYCOUNT=5
spy>> SENDFLOATPARAMETERSASSTRING=false
spy>> COMMITBEHAVIOR=serverDefault
spy>> ENABLEBULKLOAD=false
spy>> TNSSERVERNAME=
spy>> BATCHPERFORMANCEWORKAROUND=false
spy>> INITIALIZATIONSTRING=
spy>> FAILOVERPRECONNECT=false
spy>> ENABLESERVERRESULTCACHE=false
spy>> RESULTSETMETADATAOPTIONS=0
spy>> CLIENTUSER=
spy>> QUERYTIMEOUT=0
spy>> HOSTNAMEINCERTIFICATE=
spy>> FAILOVERGRANULARITY=nonAtomic
spy>> WIREPROTOCOLMODE=1
spy>> CATALOGINCLUDESSYNONYMS=true
spy>> APPLICATIONNAME=
spy>> JAVADOUBLETOSTRING=false
spy>> LOADLIBRARYPATH=
spy>> INITIALCOLUMNBUFFERSIZE=-1
spy>> IMPORTSTATEMENTPOOL=
spy>> ALTERNATESERVERS=
spy>> SDUSIZE=
spy>> KEYPASSWORD=
spy>> ENCRYPTIONMETHOD=NoEncryption
spy>> ACCOUNTINGINFO=
spy>> CONVERTNULL=1
spy>> TRUSTSTORE=
spy>> TNSNAMESFILE=
spy>> JDBCBEHAVIOR=1
spy>> FAILOVERMODE=connect
spy>> AUTHENTICATIONMETHOD=auto
spy>> LOGINTIMEOUT=0
spy>> SERVICENAME=
spy>> SERVERTYPE=
spy>> LOADBALANCING=false
spy>> SID=ORCL
spy>> WORKAROUNDS=0
spy>> INSENSITIVERESULTSETBUFFERSIZE=2048
spy>> SYSLOGINROLE=
spy>> CLIENTHOSTNAME=
spy>> FETCHTSWTZASTIMESTAMP=false
spy>> Driver Name = Oracle
spy>> Driver Version = 4.0.027033 (040328.014805)
spy>> Database Name = Oracle
spy>> Database Version = 11.1.0.6.0

spy>> Connection[18].getMetaData()
spy>> OK (DatabaseMetaData[84])

spy>> DatabaseMetaData[84].getMaxStatements()
spy>> OK (0)

spy>> Connection[18].getMetaData()
spy>> OK (DatabaseMetaData[85])

spy>> DatabaseMetaData[85].getMaxStatements()
spy>> OK (0)

spy>> Connection[18].getMetaData()
spy>> OK (DatabaseMetaData[86])

spy>> DatabaseMetaData[86].getMaxStatements()
spy>> OK (0)

spy>> Connection[18].prepareStatement(String sql)
spy>> sql = select 'AAA' AS ORCL
from DEPT
spy>> OK (PreparedStatement[17])

spy>> PreparedStatement[17].getConnection()
spy>> OK (Connection[18])

spy>> Connection[18].getMetaData()
spy>> OK (DatabaseMetaData[87])

spy>> DatabaseMetaData[87].getDriverName()
spy>> OK (Oracle)

spy>> PreparedStatement[17].getMetaData()
spy>> OK (ResultSetMetaData[16])

spy>> ResultSetMetaData[16].getColumnCount()
spy>> OK (1)

spy>> ResultSetMetaData[16].getColumnCount()
spy>> OK (1)

spy>> ResultSetMetaData[16].getColumnCount()
spy>> OK (1)

spy>> ResultSetMetaData[16].getColumnName(int column)
spy>> column = 1
spy>> OK (ORCL)

spy>> ResultSetMetaData[16].getColumnLabel(int column)
spy>> column = 1
spy>> OK (ORCL)

spy>> ResultSetMetaData[16].getColumnClassName(int column)
spy>> column = 1
spy>> OK (java.lang.String)

spy>> ResultSetMetaData[16].getColumnClassName(int column)
spy>> column = 1
spy>> OK (java.lang.String)

spy>> ResultSetMetaData[16].getColumnTypeName(int column)
spy>> column = 1
spy>> OK (char)

spy>> Connection[18].isClosed()
spy>> OK (false)

spy>> Connection[18].close()
spy>> OK

spy>> Connection[19].getMetaData()
spy>> OK (DatabaseMetaData[88])

spy>> DatabaseMetaData[88].getURL()
spy>> OK (jdbc:rkyoem:oracle://machine1:1521 ;CATALOGOPTIONS=2;CONNECTIONRETRYDELAY=1;BULKLOADBATCHSIZE=1 000;SUPPORTLINKS=false;MAXPOOLEDSTATEMENTS=0;SPYATTRIBUTES=( log=(file)c:\temp\spy_rky.log);KEYSTORE=;NEWPASSWORD=;STRING PARAMSMUSTMATCHCHARCOLUMNS=true;PROGRAMID=;ENABLECANCELTIMEO UT=false;TRUSTSTOREPASSWORD=;VALIDATESERVERCERTIFICATE=true; CODEPAGEOVERRIDE=;REFCURSORSUPPORT=true;KEYSTOREPASSWORD=;CO NNECTIONRETRYCOUNT=5;SENDFLOATPARAMETERSASSTRING=false;COMMI TBEHAVIOR=serverDefault;ENABLEBULKLOAD=false;TNSSERVERNAME=; BATCHPERFORMANCEWORKAROUND=false;INITIALIZATIONSTRING=;FAILO VERPRECONNECT=false;ENABLESERVERRESULTCACHE=false;RESULTSETM ETADATAOPTIONS=0;CLIENTUSER=;QUERYTIMEOUT=0;HOSTNAMEINCERTIF ICATE=;FAILOVERGRANULARITY=nonAtomic;WIREPROTOCOLMODE=1;CATA LOGINCLUDESSYNONYMS=true;APPLICATIONNAME=;JAVADOUBLETOSTRING =false;LOADLIBRARYPATH=;INITIALCOLUMNBUFFERSIZE=-1;IMPORTSTA TEMENTPOOL=;ALTERNATESERVERS=;SDUSIZE=;KEYPASSWORD=;ENCRYPTI ONMETHOD=NoEncryption;ACCOUNTINGINFO=;CONVERTNULL=1;TRUSTSTO RE=;TNSNAMESFILE=;JDBCBEHAVIOR=1;FAILOVERMODE=connect;AUTHEN TICATIONMETHOD=auto;LOGINTIMEOUT=0;SERVICENAME=;SERVERTYPE=; LOADBALANCING=false;SID=TEST;WORKAROUNDS=0;INSENSITIVERESULT SETBUFFERSIZE=2048;SYSLOGINROLE=;CLIENTHOSTNAME=;FETCHTSWTZA STIMESTAMP=false)

spy>> DatabaseMetaData[88].getDriverName()
spy>> OK (Oracle)

spy>> DatabaseMetaData[88].getDriverVersion()
spy>> OK (4.0.027033 (040328.014805))

spy>> DatabaseMetaData[88].getDatabaseProductName()
spy>> OK (Oracle)

spy>> DatabaseMetaData[88].getDatabaseProductVersion()
spy>> OK (11.1.0.6.0)

spy>> Connection Options :
spy>> CATALOGOPTIONS=2
spy>> CONNECTIONRETRYDELAY=1
spy>> BULKLOADBATCHSIZE=1000
spy>> SUPPORTLINKS=false
spy>> MAXPOOLEDSTATEMENTS=0
spy>> SPYATTRIBUTES=(log=(file)c:\temp\spy_rky.log)
spy>> KEYSTORE=
spy>> NEWPASSWORD=
spy>> STRINGPARAMSMUSTMATCHCHARCOLUMNS=true
spy>> PROGRAMID=
spy>> ENABLECANCELTIMEOUT=false
spy>> TRUSTSTOREPASSWORD=
spy>> VALIDATESERVERCERTIFICATE=true
spy>> CODEPAGEOVERRIDE=
spy>> REFCURSORSUPPORT=true
spy>> KEYSTOREPASSWORD=
spy>> CONNECTIONRETRYCOUNT=5
spy>> SENDFLOATPARAMETERSASSTRING=false
spy>> COMMITBEHAVIOR=serverDefault
spy>> ENABLEBULKLOAD=false
spy>> TNSSERVERNAME=
spy>> BATCHPERFORMANCEWORKAROUND=false
spy>> INITIALIZATIONSTRING=
spy>> FAILOVERPRECONNECT=false
spy>> ENABLESERVERRESULTCACHE=false
spy>> RESULTSETMETADATAOPTIONS=0
spy>> CLIENTUSER=
spy>> QUERYTIMEOUT=0
spy>> HOSTNAMEINCERTIFICATE=
spy>> FAILOVERGRANULARITY=nonAtomic
spy>> WIREPROTOCOLMODE=1
spy>> CATALOGINCLUDESSYNONYMS=true
spy>> APPLICATIONNAME=
spy>> JAVADOUBLETOSTRING=false
spy>> LOADLIBRARYPATH=
spy>> INITIALCOLUMNBUFFERSIZE=-1
spy>> IMPORTSTATEMENTPOOL=
spy>> ALTERNATESERVERS=
spy>> SDUSIZE=
spy>> KEYPASSWORD=
spy>> ENCRYPTIONMETHOD=NoEncryption
spy>> ACCOUNTINGINFO=
spy>> CONVERTNULL=1
spy>> TRUSTSTORE=
spy>> TNSNAMESFILE=
spy>> JDBCBEHAVIOR=1
spy>> FAILOVERMODE=connect
spy>> AUTHENTICATIONMETHOD=auto
spy>> LOGINTIMEOUT=0
spy>> SERVICENAME=
spy>> SERVERTYPE=
spy>> LOADBALANCING=false
spy>> SID=TEST
spy>> WORKAROUNDS=0
spy>> INSENSITIVERESULTSETBUFFERSIZE=2048
spy>> SYSLOGINROLE=
spy>> CLIENTHOSTNAME=
spy>> FETCHTSWTZASTIMESTAMP=false
spy>> Driver Name = Oracle
spy>> Driver Version = 4.0.027033 (040328.014805)
spy>> Database Name = Oracle
spy>> Database Version = 11.1.0.6.0

spy>> Connection[19].getMetaData()
spy>> OK (DatabaseMetaData[89])

spy>> DatabaseMetaData[89].getMaxStatements()
spy>> OK (0)

spy>> Connection[19].getMetaData()
spy>> OK (DatabaseMetaData[90])

spy>> DatabaseMetaData[90].getMaxStatements()
spy>> OK (0)

spy>> Connection[19].getMetaData()
spy>> OK (DatabaseMetaData[91])

spy>> DatabaseMetaData[91].getMaxStatements()
spy>> OK (0)

spy>> Connection[19].prepareStatement(String sql)
spy>> sql = select 'AAA' AS TEST
from EMP
spy>> OK (PreparedStatement[18])

spy>> PreparedStatement[18].getConnection()
spy>> OK (Connection[19])

spy>> Connection[19].getMetaData()
spy>> OK (DatabaseMetaData[92])

spy>> DatabaseMetaData[92].getDriverName()
spy>> OK (Oracle)

spy>> PreparedStatement[18].getMetaData()
spy>> OK (ResultSetMetaData[17])

spy>> ResultSetMetaData[17].getColumnCount()
spy>> OK (1)

spy>> ResultSetMetaData[17].getColumnCount()
spy>> OK (1)

spy>> ResultSetMetaData[17].getColumnCount()
spy>> OK (1)

spy>> ResultSetMetaData[17].getColumnName(int column)
spy>> column = 1
spy>> OK (TEST)

spy>> ResultSetMetaData[17].getColumnLabel(int column)
spy>> column = 1
spy>> OK (TEST)

spy>> ResultSetMetaData[17].getColumnClassName(int column)
spy>> column = 1
spy>> OK (java.lang.String)

spy>> ResultSetMetaData[17].getColumnClassName(int column)
spy>> column = 1
spy>> OK (java.lang.String)

spy>> ResultSetMetaData[17].getColumnTypeName(int column)
spy>> column = 1
spy>> OK (char)

spy>> PreparedStatement[18].close()
spy>> OK

spy>> Connection[19].isClosed()
spy>> OK (false)

spy>> Connection[19].close()
spy>> OK

spy>> Connection[20].getMetaData()
spy>> OK (DatabaseMetaData[93])

spy>> DatabaseMetaData[93].getURL()
spy>> OK (jdbc:rkyoem:oracle://machine1:1521 ;CATALOGOPTIONS=2;CONNECTIONRETRYDELAY=1;BULKLOADBATCHSIZE=1 000;SUPPORTLINKS=false;MAXPOOLEDSTATEMENTS=0;SPYATTRIBUTES=( log=(file)c:\temp\spy_rky.log);KEYSTORE=;NEWPASSWORD=;STRING PARAMSMUSTMATCHCHARCOLUMNS=true;PROGRAMID=;ENABLECANCELTIMEO UT=false;TRUSTSTOREPASSWORD=;VALIDATESERVERCERTIFICATE=true; CODEPAGEOVERRIDE=;REFCURSORSUPPORT=true;KEYSTOREPASSWORD=;CO NNECTIONRETRYCOUNT=5;SENDFLOATPARAMETERSASSTRING=false;COMMI TBEHAVIOR=serverDefault;ENABLEBULKLOAD=false;TNSSERVERNAME=; BATCHPERFORMANCEWORKAROUND=false;INITIALIZATIONSTRING=;FAILO VERPRECONNECT=false;ENABLESERVERRESULTCACHE=false;RESULTSETM ETADATAOPTIONS=0;CLIENTUSER=;QUERYTIMEOUT=0;HOSTNAMEINCERTIF ICATE=;FAILOVERGRANULARITY=nonAtomic;WIREPROTOCOLMODE=1;CATA LOGINCLUDESSYNONYMS=true;APPLICATIONNAME=;JAVADOUBLETOSTRING =false;LOADLIBRARYPATH=;INITIALCOLUMNBUFFERSIZE=-1;IMPORTSTA TEMENTPOOL=;ALTERNATESERVERS=;SDUSIZE=;KEYPASSWORD=;ENCRYPTI ONMETHOD=NoEncryption;ACCOUNTINGINFO=;CONVERTNULL=1;TRUSTSTO RE=;TNSNAMESFILE=;JDBCBEHAVIOR=1;FAILOVERMODE=connect;AUTHEN TICATIONMETHOD=auto;LOGINTIMEOUT=0;SERVICENAME=;SERVERTYPE=; LOADBALANCING=false;SID=ORCL;WORKAROUNDS=0;INSENSITIVERESULT SETBUFFERSIZE=2048;SYSLOGINROLE=;CLIENTHOSTNAME=;FETCHTSWTZA STIMESTAMP=false)

spy>> DatabaseMetaData[93].getDriverName()
spy>> OK (Oracle)

spy>> DatabaseMetaData[93].getDriverVersion()
spy>> OK (4.0.027033 (040328.014805))

spy>> DatabaseMetaData[93].getDatabaseProductName()
spy>> OK (Oracle)

spy>> DatabaseMetaData[93].getDatabaseProductVersion()
spy>> OK (11.1.0.6.0)

spy>> Connection Options :
spy>> CATALOGOPTIONS=2
spy>> CONNECTIONRETRYDELAY=1
spy>> BULKLOADBATCHSIZE=1000
spy>> SUPPORTLINKS=false
spy>> MAXPOOLEDSTATEMENTS=0
spy>> SPYATTRIBUTES=(log=(file)c:\temp\spy_rky.log)
spy>> KEYSTORE=
spy>> NEWPASSWORD=
spy>> STRINGPARAMSMUSTMATCHCHARCOLUMNS=true
spy>> PROGRAMID=
spy>> ENABLECANCELTIMEOUT=false
spy>> TRUSTSTOREPASSWORD=
spy>> VALIDATESERVERCERTIFICATE=true
spy>> CODEPAGEOVERRIDE=
spy>> REFCURSORSUPPORT=true
spy>> KEYSTOREPASSWORD=
spy>> CONNECTIONRETRYCOUNT=5
spy>> SENDFLOATPARAMETERSASSTRING=false
spy>> COMMITBEHAVIOR=serverDefault
spy>> ENABLEBULKLOAD=false
spy>> TNSSERVERNAME=
spy>> BATCHPERFORMANCEWORKAROUND=false
spy>> INITIALIZATIONSTRING=
spy>> FAILOVERPRECONNECT=false
spy>> ENABLESERVERRESULTCACHE=false
spy>> RESULTSETMETADATAOPTIONS=0
spy>> CLIENTUSER=
spy>> QUERYTIMEOUT=0
spy>> HOSTNAMEINCERTIFICATE=
spy>> FAILOVERGRANULARITY=nonAtomic
spy>> WIREPROTOCOLMODE=1
spy>> CATALOGINCLUDESSYNONYMS=true
spy>> APPLICATIONNAME=
spy>> JAVADOUBLETOSTRING=false
spy>> LOADLIBRARYPATH=
spy>> INITIALCOLUMNBUFFERSIZE=-1
spy>> IMPORTSTATEMENTPOOL=
spy>> ALTERNATESERVERS=
spy>> SDUSIZE=
spy>> KEYPASSWORD=
spy>> ENCRYPTIONMETHOD=NoEncryption
spy>> ACCOUNTINGINFO=
spy>> CONVERTNULL=1
spy>> TRUSTSTORE=
spy>> TNSNAMESFILE=
spy>> JDBCBEHAVIOR=1
spy>> FAILOVERMODE=connect
spy>> AUTHENTICATIONMETHOD=auto
spy>> LOGINTIMEOUT=0
spy>> SERVICENAME=
spy>> SERVERTYPE=
spy>> LOADBALANCING=false
spy>> SID=ORCL
spy>> WORKAROUNDS=0
spy>> INSENSITIVERESULTSETBUFFERSIZE=2048
spy>> SYSLOGINROLE=
spy>> CLIENTHOSTNAME=
spy>> FETCHTSWTZASTIMESTAMP=false
spy>> Driver Name = Oracle
spy>> Driver Version = 4.0.027033 (040328.014805)
spy>> Database Name = Oracle
spy>> Database Version = 11.1.0.6.0

spy>> Connection[20].getMetaData()
spy>> OK (DatabaseMetaData[94])

spy>> DatabaseMetaData[94].getMaxStatements()
spy>> OK (0)

spy>> Connection[20].getMetaData()
spy>> OK (DatabaseMetaData[95])

spy>> DatabaseMetaData[95].getMaxStatements()
spy>> OK (0)

spy>> Connection[20].getMetaData()
spy>> OK (DatabaseMetaData[96])

spy>> DatabaseMetaData[96].getMaxStatements()
spy>> OK (0)

spy>> Connection[20].prepareStatement(String sql)
spy>> sql = select 'AAA' AS ORCL
from DEPT
spy>> OK (PreparedStatement[19])

spy>> PreparedStatement[19].getConnection()
spy>> OK (Connection[20])

spy>> Connection[20].getMetaData()
spy>> OK (DatabaseMetaData[97])

spy>> DatabaseMetaData[97].getDriverName()
spy>> OK (Oracle)

spy>> PreparedStatement[19].getMetaData()
spy>> OK (ResultSetMetaData[18])

spy>> ResultSetMetaData[18].getColumnCount()
spy>> OK (1)

spy>> ResultSetMetaData[18].getColumnCount()
spy>> OK (1)

spy>> ResultSetMetaData[18].getColumnCount()
spy>> OK (1)

spy>> ResultSetMetaData[18].getColumnName(int column)
spy>> column = 1
spy>> OK (ORCL)

spy>> ResultSetMetaData[18].getColumnLabel(int column)
spy>> column = 1
spy>> OK (ORCL)

spy>> ResultSetMetaData[18].getColumnClassName(int column)
spy>> column = 1
spy>> OK (java.lang.String)

spy>> ResultSetMetaData[18].getColumnClassName(int column)
spy>> column = 1
spy>> OK (java.lang.String)

spy>> ResultSetMetaData[18].getColumnTypeName(int column)
spy>> column = 1
spy>> OK (char)

spy>> Connection[20].isClosed()
spy>> OK (false)

spy>> Connection[20].close()
spy>> OK

spy>> Connection[21].getMetaData()
spy>> OK (DatabaseMetaData[98])

spy>> DatabaseMetaData[98].getURL()
spy>> OK (jdbc:rkyoem:oracle://machine1:1521 ;CATALOGOPTIONS=2;CONNECTIONRETRYDELAY=1;BULKLOADBATCHSIZE=1 000;SUPPORTLINKS=false;MAXPOOLEDSTATEMENTS=0;SPYATTRIBUTES=( log=(file)c:\temp\spy_rky.log);KEYSTORE=;NEWPASSWORD=;STRING PARAMSMUSTMATCHCHARCOLUMNS=true;PROGRAMID=;ENABLECANCELTIMEO UT=false;TRUSTSTOREPASSWORD=;VALIDATESERVERCERTIFICATE=true; CODEPAGEOVERRIDE=;REFCURSORSUPPORT=true;KEYSTOREPASSWORD=;CO NNECTIONRETRYCOUNT=5;SENDFLOATPARAMETERSASSTRING=false;COMMI TBEHAVIOR=serverDefault;ENABLEBULKLOAD=false;TNSSERVERNAME=; BATCHPERFORMANCEWORKAROUND=false;INITIALIZATIONSTRING=;FAILO VERPRECONNECT=false;ENABLESERVERRESULTCACHE=false;RESULTSETM ETADATAOPTIONS=0;CLIENTUSER=;QUERYTIMEOUT=0;HOSTNAMEINCERTIF ICATE=;FAILOVERGRANULARITY=nonAtomic;WIREPROTOCOLMODE=1;CATA LOGINCLUDESSYNONYMS=true;APPLICATIONNAME=;JAVADOUBLETOSTRING =false;LOADLIBRARYPATH=;INITIALCOLUMNBUFFERSIZE=-1;IMPORTSTA TEMENTPOOL=;ALTERNATESERVERS=;SDUSIZE=;KEYPASSWORD=;ENCRYPTI ONMETHOD=NoEncryption;ACCOUNTINGINFO=;CONVERTNULL=1;TRUSTSTO RE=;TNSNAMESFILE=;JDBCBEHAVIOR=1;FAILOVERMODE=connect;AUTHEN TICATIONMETHOD=auto;LOGINTIMEOUT=0;SERVICENAME=;SERVERTYPE=; LOADBALANCING=false;SID=TEST;WORKAROUNDS=0;INSENSITIVERESULT SETBUFFERSIZE=2048;SYSLOGINROLE=;CLIENTHOSTNAME=;FETCHTSWTZA STIMESTAMP=false)

spy>> DatabaseMetaData[98].getDriverName()
spy>> OK (Oracle)

spy>> DatabaseMetaData[98].getDriverVersion()
spy>> OK (4.0.027033 (040328.014805))

spy>> DatabaseMetaData[98].getDatabaseProductName()
spy>> OK (Oracle)

spy>> DatabaseMetaData[98].getDatabaseProductVersion()
spy>> OK (11.1.0.6.0)

spy>> Connection Options :
spy>> CATALOGOPTIONS=2
spy>> CONNECTIONRETRYDELAY=1
spy>> BULKLOADBATCHSIZE=1000
spy>> SUPPORTLINKS=false
spy>> MAXPOOLEDSTATEMENTS=0
spy>> SPYATTRIBUTES=(log=(file)c:\temp\spy_rky.log)
spy>> KEYSTORE=
spy>> NEWPASSWORD=
spy>> STRINGPARAMSMUSTMATCHCHARCOLUMNS=true
spy>> PROGRAMID=
spy>> ENABLECANCELTIMEOUT=false
spy>> TRUSTSTOREPASSWORD=
spy>> VALIDATESERVERCERTIFICATE=true
spy>> CODEPAGEOVERRIDE=
spy>> REFCURSORSUPPORT=true
spy>> KEYSTOREPASSWORD=
spy>> CONNECTIONRETRYCOUNT=5
spy>> SENDFLOATPARAMETERSASSTRING=false
spy>> COMMITBEHAVIOR=serverDefault
spy>> ENABLEBULKLOAD=false
spy>> TNSSERVERNAME=
spy>> BATCHPERFORMANCEWORKAROUND=false
spy>> INITIALIZATIONSTRING=
spy>> FAILOVERPRECONNECT=false
spy>> ENABLESERVERRESULTCACHE=false
spy>> RESULTSETMETADATAOPTIONS=0
spy>> CLIENTUSER=
spy>> QUERYTIMEOUT=0
spy>> HOSTNAMEINCERTIFICATE=
spy>> FAILOVERGRANULARITY=nonAtomic
spy>> WIREPROTOCOLMODE=1
spy>> CATALOGINCLUDESSYNONYMS=true
spy>> APPLICATIONNAME=
spy>> JAVADOUBLETOSTRING=false
spy>> LOADLIBRARYPATH=
spy>> INITIALCOLUMNBUFFERSIZE=-1
spy>> IMPORTSTATEMENTPOOL=
spy>> ALTERNATESERVERS=
spy>> SDUSIZE=
spy>> KEYPASSWORD=
spy>> ENCRYPTIONMETHOD=NoEncryption
spy>> ACCOUNTINGINFO=
spy>> CONVERTNULL=1
spy>> TRUSTSTORE=
spy>> TNSNAMESFILE=
spy>> JDBCBEHAVIOR=1
spy>> FAILOVERMODE=connect
spy>> AUTHENTICATIONMETHOD=auto
spy>> LOGINTIMEOUT=0
spy>> SERVICENAME=
spy>> SERVERTYPE=
spy>> LOADBALANCING=false
spy>> SID=TEST
spy>> WORKAROUNDS=0
spy>> INSENSITIVERESULTSETBUFFERSIZE=2048
spy>> SYSLOGINROLE=
spy>> CLIENTHOSTNAME=
spy>> FETCHTSWTZASTIMESTAMP=false
spy>> Driver Name = Oracle
spy>> Driver Version = 4.0.027033 (040328.014805)
spy>> Database Name = Oracle
spy>> Database Version = 11.1.0.6.0

spy>> Connection[21].getMetaData()
spy>> OK (DatabaseMetaData[99])

spy>> DatabaseMetaData[99].getMaxStatements()
spy>> OK (0)

spy>> Connection[21].getMetaData()
spy>> OK (DatabaseMetaData[100])

spy>> DatabaseMetaData[100].getMaxStatements()
spy>> OK (0)

spy>> Connection[21].getMetaData()
spy>> OK (DatabaseMetaData[101])

spy>> DatabaseMetaData[101].getMaxStatements()
spy>> OK (0)

spy>> Connection[21].prepareStatement(String sql)
spy>> sql = select 'AAA' AS TEST
from EMP
spy>> OK (PreparedStatement[20])

spy>> PreparedStatement[20].getConnection()
spy>> OK (Connection[21])

spy>> Connection[21].getMetaData()
spy>> OK (DatabaseMetaData[102])

spy>> DatabaseMetaData[102].getDriverName()
spy>> OK (Oracle)

spy>> PreparedStatement[20].getMetaData()
spy>> OK (ResultSetMetaData[19])

spy>> ResultSetMetaData[19].getColumnCount()
spy>> OK (1)

spy>> ResultSetMetaData[19].getColumnCount()
spy>> OK (1)

spy>> ResultSetMetaData[19].getColumnCount()
spy>> OK (1)

spy>> ResultSetMetaData[19].getColumnName(int column)
spy>> column = 1
spy>> OK (TEST)

spy>> ResultSetMetaData[19].getColumnLabel(int column)
spy>> column = 1
spy>> OK (TEST)

spy>> ResultSetMetaData[19].getColumnClassName(int column)
spy>> column = 1
spy>> OK (java.lang.String)

spy>> ResultSetMetaData[19].getColumnClassName(int column)
spy>> column = 1
spy>> OK (java.lang.String)

spy>> ResultSetMetaData[19].getColumnTypeName(int column)
spy>> column = 1
spy>> OK (char)

spy>> PreparedStatement[20].close()
spy>> OK

[Updated on: Wed, 18 August 2010 03:43]

Report message to a moderator

Re: java.sql.Statement has been closed strangely when inner joining 2 datasets [message #553746 is a reply to message #553563] Wed, 18 August 2010 15:56 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Ricky,

Can you log a bug for this? I assume you based your code on the
sampledb driver?

Jason


On 8/17/2010 11:38 PM, Ricky wrote:
> I also turned on the DataDirect Spy Logging to troubleshoot birt. I saw
> the error from the ui. But I could not see any exception in the sys log
> pasted below:
>
> spy>> Connection[15].isClosed()
> spy>> OK (false)
>
> spy>> Connection[15].close()
> spy>> OK
>
> spy>> Connection[16].getMetaData()
> spy>> OK (DatabaseMetaData[73])
>
> spy>> DatabaseMetaData[73].getURL()
> spy>> OK (jdbc:rkyoem:oracle://10.80.5.29:1521
> ;CATALOGOPTIONS=2;CONNECTIONRETRYDELAY=1;BULKLOADBATCHSIZE=1
> 000;SUPPORTLINKS=false;MAXPOOLEDSTATEMENTS=0;SPYATTRIBUTES=(
> log=(file)c:\temp\spy_rky.log);KEYSTORE=;NEWPASSWORD=;STRING
> PARAMSMUSTMATCHCHARCOLUMNS=true;PROGRAMID=;ENABLECANCELTIMEO
> UT=false;TRUSTSTOREPASSWORD=;VALIDATESERVERCERTIFICATE=true;
> CODEPAGEOVERRIDE=;REFCURSORSUPPORT=true;KEYSTOREPASSWORD=;CO
> NNECTIONRETRYCOUNT=5;SENDFLOATPARAMETERSASSTRING=false;COMMI
> TBEHAVIOR=serverDefault;ENABLEBULKLOAD=false;TNSSERVERNAME=;
> BATCHPERFORMANCEWORKAROUND=false;INITIALIZATIONSTRING=;FAILO
> VERPRECONNECT=false;ENABLESERVERRESULTCACHE=false;RESULTSETM
> ETADATAOPTIONS=0;CLIENTUSER=;QUERYTIMEOUT=0;HOSTNAMEINCERTIF
> ICATE=;FAILOVERGRANULARITY=nonAtomic;WIREPROTOCOLMODE=1;CATA
> LOGINCLUDESSYNONYMS=true;APPLICATIONNAME=;JAVADOUBLETOSTRING
> =false;LOADLIBRARYPATH=;INITIALCOLUMNBUFFERSIZE=-1;IMPORTSTA
> TEMENTPOOL=;ALTERNATESERVERS=;SDUSIZE=;KEYPASSWORD=;ENCRYPTI
> ONMETHOD=NoEncryption;ACCOUNTINGINFO=;CONVERTNULL=1;TRUSTSTO
> RE=;TNSNAMESFILE=;JDBCBEHAVIOR=1;FAILOVERMODE=connect;AUTHEN
> TICATIONMETHOD=auto;LOGINTIMEOUT=0;SERVICENAME=;SERVERTYPE=;
> LOADBALANCING=false;SID=ORCL;WORKAROUNDS=0;INSENSITIVERESULT
> SETBUFFERSIZE=2048;SYSLOGINROLE=;CLIENTHOSTNAME=;FETCHTSWTZA
> STIMESTAMP=false)
>
> spy>> DatabaseMetaData[73].getDriverName()
> spy>> OK (Oracle)
>
> spy>> DatabaseMetaData[73].getDriverVersion()
> spy>> OK (4.0.027033 (040328.014805))
>
> spy>> DatabaseMetaData[73].getDatabaseProductName()
> spy>> OK (Oracle)
>
> spy>> DatabaseMetaData[73].getDatabaseProductVersion()
> spy>> OK (11.1.0.6.0)
>
> spy>> Connection Options : spy>> CATALOGOPTIONS=2
> spy>> CONNECTIONRETRYDELAY=1
> spy>> BULKLOADBATCHSIZE=1000
> spy>> SUPPORTLINKS=false
> spy>> MAXPOOLEDSTATEMENTS=0
> spy>> SPYATTRIBUTES=(log=(file)c:\temp\spy_rky.log)
> spy>> KEYSTORE=
> spy>> NEWPASSWORD=
> spy>> STRINGPARAMSMUSTMATCHCHARCOLUMNS=true
> spy>> PROGRAMID=
> spy>> ENABLECANCELTIMEOUT=false
> spy>> TRUSTSTOREPASSWORD=
> spy>> VALIDATESERVERCERTIFICATE=true
> spy>> CODEPAGEOVERRIDE=
> spy>> REFCURSORSUPPORT=true
> spy>> KEYSTOREPASSWORD=
> spy>> CONNECTIONRETRYCOUNT=5
> spy>> SENDFLOATPARAMETERSASSTRING=false
> spy>> COMMITBEHAVIOR=serverDefault
> spy>> ENABLEBULKLOAD=false
> spy>> TNSSERVERNAME=
> spy>> BATCHPERFORMANCEWORKAROUND=false
> spy>> INITIALIZATIONSTRING=
> spy>> FAILOVERPRECONNECT=false
> spy>> ENABLESERVERRESULTCACHE=false
> spy>> RESULTSETMETADATAOPTIONS=0
> spy>> CLIENTUSER=
> spy>> QUERYTIMEOUT=0
> spy>> HOSTNAMEINCERTIFICATE=
> spy>> FAILOVERGRANULARITY=nonAtomic
> spy>> WIREPROTOCOLMODE=1
> spy>> CATALOGINCLUDESSYNONYMS=true
> spy>> APPLICATIONNAME=
> spy>> JAVADOUBLETOSTRING=false
> spy>> LOADLIBRARYPATH=
> spy>> INITIALCOLUMNBUFFERSIZE=-1
> spy>> IMPORTSTATEMENTPOOL=
> spy>> ALTERNATESERVERS=
> spy>> SDUSIZE=
> spy>> KEYPASSWORD=
> spy>> ENCRYPTIONMETHOD=NoEncryption
> spy>> ACCOUNTINGINFO=
> spy>> CONVERTNULL=1
> spy>> TRUSTSTORE=
> spy>> TNSNAMESFILE=
> spy>> JDBCBEHAVIOR=1
> spy>> FAILOVERMODE=connect
> spy>> AUTHENTICATIONMETHOD=auto
> spy>> LOGINTIMEOUT=0
> spy>> SERVICENAME=
> spy>> SERVERTYPE=
> spy>> LOADBALANCING=false
> spy>> SID=ORCL
> spy>> WORKAROUNDS=0
> spy>> INSENSITIVERESULTSETBUFFERSIZE=2048
> spy>> SYSLOGINROLE=
> spy>> CLIENTHOSTNAME=
> spy>> FETCHTSWTZASTIMESTAMP=false
> spy>> Driver Name = Oracle
> spy>> Driver Version = 4.0.027033 (040328.014805)
> spy>> Database Name = Oracle
> spy>> Database Version = 11.1.0.6.0
>
> spy>> Connection[16].getMetaData()
> spy>> OK (DatabaseMetaData[74])
>
> spy>> DatabaseMetaData[74].getMaxStatements()
> spy>> OK (0)
>
> spy>> Connection[16].getMetaData()
> spy>> OK (DatabaseMetaData[75])
>
> spy>> DatabaseMetaData[75].getMaxStatements()
> spy>> OK (0)
>
> spy>> Connection[16].getMetaData()
> spy>> OK (DatabaseMetaData[76])
>
> spy>> DatabaseMetaData[76].getMaxStatements()
> spy>> OK (0)
>
> spy>> Connection[16].prepareStatement(String sql)
> spy>> sql = select 'AAA' AS ORCL
> from DEPT
> spy>> OK (PreparedStatement[15])
>
> spy>> PreparedStatement[15].getConnection()
> spy>> OK (Connection[16])
>
> spy>> Connection[16].getMetaData()
> spy>> OK (DatabaseMetaData[77])
>
> spy>> DatabaseMetaData[77].getDriverName()
> spy>> OK (Oracle)
>
> spy>> PreparedStatement[15].getMetaData()
> spy>> OK (ResultSetMetaData[14])
>
> spy>> ResultSetMetaData[14].getColumnCount()
> spy>> OK (1)
>
> spy>> ResultSetMetaData[14].getColumnCount()
> spy>> OK (1)
>
> spy>> ResultSetMetaData[14].getColumnCount()
> spy>> OK (1)
>
> spy>> ResultSetMetaData[14].getColumnName(int column)
> spy>> column = 1
> spy>> OK (ORCL)
>
> spy>> ResultSetMetaData[14].getColumnLabel(int column)
> spy>> column = 1
> spy>> OK (ORCL)
>
> spy>> ResultSetMetaData[14].getColumnClassName(int column)
> spy>> column = 1
> spy>> OK (java.lang.String)
>
> spy>> ResultSetMetaData[14].getColumnClassName(int column)
> spy>> column = 1
> spy>> OK (java.lang.String)
>
> spy>> ResultSetMetaData[14].getColumnTypeName(int column)
> spy>> column = 1
> spy>> OK (char)
>
> spy>> Connection[16].isClosed()
> spy>> OK (false)
>
> spy>> Connection[16].close()
> spy>> OK
>
> spy>> Connection[17].getMetaData()
> spy>> OK (DatabaseMetaData[78])
>
> spy>> DatabaseMetaData[78].getURL()
> spy>> OK (jdbc:rkyoem:oracle://10.80.5.29:1521
> ;CATALOGOPTIONS=2;CONNECTIONRETRYDELAY=1;BULKLOADBATCHSIZE=1
> 000;SUPPORTLINKS=false;MAXPOOLEDSTATEMENTS=0;SPYATTRIBUTES=(
> log=(file)c:\temp\spy_rky.log);KEYSTORE=;NEWPASSWORD=;STRING
> PARAMSMUSTMATCHCHARCOLUMNS=true;PROGRAMID=;ENABLECANCELTIMEO
> UT=false;TRUSTSTOREPASSWORD=;VALIDATESERVERCERTIFICATE=true;
> CODEPAGEOVERRIDE=;REFCURSORSUPPORT=true;KEYSTOREPASSWORD=;CO
> NNECTIONRETRYCOUNT=5;SENDFLOATPARAMETERSASSTRING=false;COMMI
> TBEHAVIOR=serverDefault;ENABLEBULKLOAD=false;TNSSERVERNAME=;
> BATCHPERFORMANCEWORKAROUND=false;INITIALIZATIONSTRING=;FAILO
> VERPRECONNECT=false;ENABLESERVERRESULTCACHE=false;RESULTSETM
> ETADATAOPTIONS=0;CLIENTUSER=;QUERYTIMEOUT=0;HOSTNAMEINCERTIF
> ICATE=;FAILOVERGRANULARITY=nonAtomic;WIREPROTOCOLMODE=1;CATA
> LOGINCLUDESSYNONYMS=true;APPLICATIONNAME=;JAVADOUBLETOSTRING
> =false;LOADLIBRARYPATH=;INITIALCOLUMNBUFFERSIZE=-1;IMPORTSTA
> TEMENTPOOL=;ALTERNATESERVERS=;SDUSIZE=;KEYPASSWORD=;ENCRYPTI
> ONMETHOD=NoEncryption;ACCOUNTINGINFO=;CONVERTNULL=1;TRUSTSTO
> RE=;TNSNAMESFILE=;JDBCBEHAVIOR=1;FAILOVERMODE=connect;AUTHEN
> TICATIONMETHOD=auto;LOGINTIMEOUT=0;SERVICENAME=;SERVERTYPE=;
> LOADBALANCING=false;SID=TEST;WORKAROUNDS=0;INSENSITIVERESULT
> SETBUFFERSIZE=2048;SYSLOGINROLE=;CLIENTHOSTNAME=;FETCHTSWTZA
> STIMESTAMP=false)
>
> spy>> DatabaseMetaData[78].getDriverName()
> spy>> OK (Oracle)
>
> spy>> DatabaseMetaData[78].getDriverVersion()
> spy>> OK (4.0.027033 (040328.014805))
>
> spy>> DatabaseMetaData[78].getDatabaseProductName()
> spy>> OK (Oracle)
>
> spy>> DatabaseMetaData[78].getDatabaseProductVersion()
> spy>> OK (11.1.0.6.0)
>
> spy>> Connection Options : spy>> CATALOGOPTIONS=2
> spy>> CONNECTIONRETRYDELAY=1
> spy>> BULKLOADBATCHSIZE=1000
> spy>> SUPPORTLINKS=false
> spy>> MAXPOOLEDSTATEMENTS=0
> spy>> SPYATTRIBUTES=(log=(file)c:\temp\spy_rky.log)
> spy>> KEYSTORE=
> spy>> NEWPASSWORD=
> spy>> STRINGPARAMSMUSTMATCHCHARCOLUMNS=true
> spy>> PROGRAMID=
> spy>> ENABLECANCELTIMEOUT=false
> spy>> TRUSTSTOREPASSWORD=
> spy>> VALIDATESERVERCERTIFICATE=true
> spy>> CODEPAGEOVERRIDE=
> spy>> REFCURSORSUPPORT=true
> spy>> KEYSTOREPASSWORD=
> spy>> CONNECTIONRETRYCOUNT=5
> spy>> SENDFLOATPARAMETERSASSTRING=false
> spy>> COMMITBEHAVIOR=serverDefault
> spy>> ENABLEBULKLOAD=false
> spy>> TNSSERVERNAME=
> spy>> BATCHPERFORMANCEWORKAROUND=false
> spy>> INITIALIZATIONSTRING=
> spy>> FAILOVERPRECONNECT=false
> spy>> ENABLESERVERRESULTCACHE=false
> spy>> RESULTSETMETADATAOPTIONS=0
> spy>> CLIENTUSER=
> spy>> QUERYTIMEOUT=0
> spy>> HOSTNAMEINCERTIFICATE=
> spy>> FAILOVERGRANULARITY=nonAtomic
> spy>> WIREPROTOCOLMODE=1
> spy>> CATALOGINCLUDESSYNONYMS=true
> spy>> APPLICATIONNAME=
> spy>> JAVADOUBLETOSTRING=false
> spy>> LOADLIBRARYPATH=
> spy>> INITIALCOLUMNBUFFERSIZE=-1
> spy>> IMPORTSTATEMENTPOOL=
> spy>> ALTERNATESERVERS=
> spy>> SDUSIZE=
> spy>> KEYPASSWORD=
> spy>> ENCRYPTIONMETHOD=NoEncryption
> spy>> ACCOUNTINGINFO=
> spy>> CONVERTNULL=1
> spy>> TRUSTSTORE=
> spy>> TNSNAMESFILE=
> spy>> JDBCBEHAVIOR=1
> spy>> FAILOVERMODE=connect
> spy>> AUTHENTICATIONMETHOD=auto
> spy>> LOGINTIMEOUT=0
> spy>> SERVICENAME=
> spy>> SERVERTYPE=
> spy>> LOADBALANCING=false
> spy>> SID=TEST
> spy>> WORKAROUNDS=0
> spy>> INSENSITIVERESULTSETBUFFERSIZE=2048
> spy>> SYSLOGINROLE=
> spy>> CLIENTHOSTNAME=
> spy>> FETCHTSWTZASTIMESTAMP=false
> spy>> Driver Name = Oracle
> spy>> Driver Version = 4.0.027033 (040328.014805)
> spy>> Database Name = Oracle
> spy>> Database Version = 11.1.0.6.0
>
> spy>> Connection[17].getMetaData()
> spy>> OK (DatabaseMetaData[79])
>
> spy>> DatabaseMetaData[79].getMaxStatements()
> spy>> OK (0)
>
> spy>> Connection[17].getMetaData()
> spy>> OK (DatabaseMetaData[80])
>
> spy>> DatabaseMetaData[80].getMaxStatements()
> spy>> OK (0)
>
> spy>> Connection[17].getMetaData()
> spy>> OK (DatabaseMetaData[81])
>
> spy>> DatabaseMetaData[81].getMaxStatements()
> spy>> OK (0)
>
> spy>> Connection[17].prepareStatement(String sql)
> spy>> sql = select 'AAA' AS TEST
> from EMP
> spy>> OK (PreparedStatement[16])
>
> spy>> PreparedStatement[16].getConnection()
> spy>> OK (Connection[17])
>
> spy>> Connection[17].getMetaData()
> spy>> OK (DatabaseMetaData[82])
>
> spy>> DatabaseMetaData[82].getDriverName()
> spy>> OK (Oracle)
>
> spy>> PreparedStatement[16].getMetaData()
> spy>> OK (ResultSetMetaData[15])
>
> spy>> ResultSetMetaData[15].getColumnCount()
> spy>> OK (1)
>
> spy>> ResultSetMetaData[15].getColumnCount()
> spy>> OK (1)
>
> spy>> ResultSetMetaData[15].getColumnCount()
> spy>> OK (1)
>
> spy>> ResultSetMetaData[15].getColumnName(int column)
> spy>> column = 1
> spy>> OK (TEST)
>
> spy>> ResultSetMetaData[15].getColumnLabel(int column)
> spy>> column = 1
> spy>> OK (TEST)
>
> spy>> ResultSetMetaData[15].getColumnClassName(int column)
> spy>> column = 1
> spy>> OK (java.lang.String)
>
> spy>> ResultSetMetaData[15].getColumnClassName(int column)
> spy>> column = 1
> spy>> OK (java.lang.String)
>
> spy>> ResultSetMetaData[15].getColumnTypeName(int column)
> spy>> column = 1
> spy>> OK (char)
>
> spy>> PreparedStatement[16].close()
> spy>> OK
>
> spy>> Connection[17].isClosed()
> spy>> OK (false)
>
> spy>> Connection[17].close()
> spy>> OK
>
> spy>> Connection[18].getMetaData()
> spy>> OK (DatabaseMetaData[83])
>
> spy>> DatabaseMetaData[83].getURL()
> spy>> OK (jdbc:rkyoem:oracle://10.80.5.29:1521
> ;CATALOGOPTIONS=2;CONNECTIONRETRYDELAY=1;BULKLOADBATCHSIZE=1
> 000;SUPPORTLINKS=false;MAXPOOLEDSTATEMENTS=0;SPYATTRIBUTES=(
> log=(file)c:\temp\spy_rky.log);KEYSTORE=;NEWPASSWORD=;STRING
> PARAMSMUSTMATCHCHARCOLUMNS=true;PROGRAMID=;ENABLECANCELTIMEO
> UT=false;TRUSTSTOREPASSWORD=;VALIDATESERVERCERTIFICATE=true;
> CODEPAGEOVERRIDE=;REFCURSORSUPPORT=true;KEYSTOREPASSWORD=;CO
> NNECTIONRETRYCOUNT=5;SENDFLOATPARAMETERSASSTRING=false;COMMI
> TBEHAVIOR=serverDefault;ENABLEBULKLOAD=false;TNSSERVERNAME=;
> BATCHPERFORMANCEWORKAROUND=false;INITIALIZATIONSTRING=;FAILO
> VERPRECONNECT=false;ENABLESERVERRESULTCACHE=false;RESULTSETM
> ETADATAOPTIONS=0;CLIENTUSER=;QUERYTIMEOUT=0;HOSTNAMEINCERTIF
> ICATE=;FAILOVERGRANULARITY=nonAtomic;WIREPROTOCOLMODE=1;CATA
> LOGINCLUDESSYNONYMS=true;APPLICATIONNAME=;JAVADOUBLETOSTRING
> =false;LOADLIBRARYPATH=;INITIALCOLUMNBUFFERSIZE=-1;IMPORTSTA
> TEMENTPOOL=;ALTERNATESERVERS=;SDUSIZE=;KEYPASSWORD=;ENCRYPTI
> ONMETHOD=NoEncryption;ACCOUNTINGINFO=;CONVERTNULL=1;TRUSTSTO
> RE=;TNSNAMESFILE=;JDBCBEHAVIOR=1;FAILOVERMODE=connect;AUTHEN
> TICATIONMETHOD=auto;LOGINTIMEOUT=0;SERVICENAME=;SERVERTYPE=;
> LOADBALANCING=false;SID=ORCL;WORKAROUNDS=0;INSENSITIVERESULT
> SETBUFFERSIZE=2048;SYSLOGINROLE=;CLIENTHOSTNAME=;FETCHTSWTZA
> STIMESTAMP=false)
>
> spy>> DatabaseMetaData[83].getDriverName()
> spy>> OK (Oracle)
>
> spy>> DatabaseMetaData[83].getDriverVersion()
> spy>> OK (4.0.027033 (040328.014805))
>
> spy>> DatabaseMetaData[83].getDatabaseProductName()
> spy>> OK (Oracle)
>
> spy>> DatabaseMetaData[83].getDatabaseProductVersion()
> spy>> OK (11.1.0.6.0)
>
> spy>> Connection Options : spy>> CATALOGOPTIONS=2
> spy>> CONNECTIONRETRYDELAY=1
> spy>> BULKLOADBATCHSIZE=1000
> spy>> SUPPORTLINKS=false
> spy>> MAXPOOLEDSTATEMENTS=0
> spy>> SPYATTRIBUTES=(log=(file)c:\temp\spy_rky.log)
> spy>> KEYSTORE=
> spy>> NEWPASSWORD=
> spy>> STRINGPARAMSMUSTMATCHCHARCOLUMNS=true
> spy>> PROGRAMID=
> spy>> ENABLECANCELTIMEOUT=false
> spy>> TRUSTSTOREPASSWORD=
> spy>> VALIDATESERVERCERTIFICATE=true
> spy>> CODEPAGEOVERRIDE=
> spy>> REFCURSORSUPPORT=true
> spy>> KEYSTOREPASSWORD=
> spy>> CONNECTIONRETRYCOUNT=5
> spy>> SENDFLOATPARAMETERSASSTRING=false
> spy>> COMMITBEHAVIOR=serverDefault
> spy>> ENABLEBULKLOAD=false
> spy>> TNSSERVERNAME=
> spy>> BATCHPERFORMANCEWORKAROUND=false
> spy>> INITIALIZATIONSTRING=
> spy>> FAILOVERPRECONNECT=false
> spy>> ENABLESERVERRESULTCACHE=false
> spy>> RESULTSETMETADATAOPTIONS=0
> spy>> CLIENTUSER=
> spy>> QUERYTIMEOUT=0
> spy>> HOSTNAMEINCERTIFICATE=
> spy>> FAILOVERGRANULARITY=nonAtomic
> spy>> WIREPROTOCOLMODE=1
> spy>> CATALOGINCLUDESSYNONYMS=true
> spy>> APPLICATIONNAME=
> spy>> JAVADOUBLETOSTRING=false
> spy>> LOADLIBRARYPATH=
> spy>> INITIALCOLUMNBUFFERSIZE=-1
> spy>> IMPORTSTATEMENTPOOL=
> spy>> ALTERNATESERVERS=
> spy>> SDUSIZE=
> spy>> KEYPASSWORD=
> spy>> ENCRYPTIONMETHOD=NoEncryption
> spy>> ACCOUNTINGINFO=
> spy>> CONVERTNULL=1
> spy>> TRUSTSTORE=
> spy>> TNSNAMESFILE=
> spy>> JDBCBEHAVIOR=1
> spy>> FAILOVERMODE=connect
> spy>> AUTHENTICATIONMETHOD=auto
> spy>> LOGINTIMEOUT=0
> spy>> SERVICENAME=
> spy>> SERVERTYPE=
> spy>> LOADBALANCING=false
> spy>> SID=ORCL
> spy>> WORKAROUNDS=0
> spy>> INSENSITIVERESULTSETBUFFERSIZE=2048
> spy>> SYSLOGINROLE=
> spy>> CLIENTHOSTNAME=
> spy>> FETCHTSWTZASTIMESTAMP=false
> spy>> Driver Name = Oracle
> spy>> Driver Version = 4.0.027033 (040328.014805)
> spy>> Database Name = Oracle
> spy>> Database Version = 11.1.0.6.0
>
> spy>> Connection[18].getMetaData()
> spy>> OK (DatabaseMetaData[84])
>
> spy>> DatabaseMetaData[84].getMaxStatements()
> spy>> OK (0)
>
> spy>> Connection[18].getMetaData()
> spy>> OK (DatabaseMetaData[85])
>
> spy>> DatabaseMetaData[85].getMaxStatements()
> spy>> OK (0)
>
> spy>> Connection[18].getMetaData()
> spy>> OK (DatabaseMetaData[86])
>
> spy>> DatabaseMetaData[86].getMaxStatements()
> spy>> OK (0)
>
> spy>> Connection[18].prepareStatement(String sql)
> spy>> sql = select 'AAA' AS ORCL
> from DEPT
> spy>> OK (PreparedStatement[17])
>
> spy>> PreparedStatement[17].getConnection()
> spy>> OK (Connection[18])
>
> spy>> Connection[18].getMetaData()
> spy>> OK (DatabaseMetaData[87])
>
> spy>> DatabaseMetaData[87].getDriverName()
> spy>> OK (Oracle)
>
> spy>> PreparedStatement[17].getMetaData()
> spy>> OK (ResultSetMetaData[16])
>
> spy>> ResultSetMetaData[16].getColumnCount()
> spy>> OK (1)
>
> spy>> ResultSetMetaData[16].getColumnCount()
> spy>> OK (1)
>
> spy>> ResultSetMetaData[16].getColumnCount()
> spy>> OK (1)
>
> spy>> ResultSetMetaData[16].getColumnName(int column)
> spy>> column = 1
> spy>> OK (ORCL)
>
> spy>> ResultSetMetaData[16].getColumnLabel(int column)
> spy>> column = 1
> spy>> OK (ORCL)
>
> spy>> ResultSetMetaData[16].getColumnClassName(int column)
> spy>> column = 1
> spy>> OK (java.lang.String)
>
> spy>> ResultSetMetaData[16].getColumnClassName(int column)
> spy>> column = 1
> spy>> OK (java.lang.String)
>
> spy>> ResultSetMetaData[16].getColumnTypeName(int column)
> spy>> column = 1
> spy>> OK (char)
>
> spy>> Connection[18].isClosed()
> spy>> OK (false)
>
> spy>> Connection[18].close()
> spy>> OK
>
> spy>> Connection[19].getMetaData()
> spy>> OK (DatabaseMetaData[88])
>
> spy>> DatabaseMetaData[88].getURL()
> spy>> OK (jdbc:rkyoem:oracle://10.80.5.29:1521
> ;CATALOGOPTIONS=2;CONNECTIONRETRYDELAY=1;BULKLOADBATCHSIZE=1
> 000;SUPPORTLINKS=false;MAXPOOLEDSTATEMENTS=0;SPYATTRIBUTES=(
> log=(file)c:\temp\spy_rky.log);KEYSTORE=;NEWPASSWORD=;STRING
> PARAMSMUSTMATCHCHARCOLUMNS=true;PROGRAMID=;ENABLECANCELTIMEO
> UT=false;TRUSTSTOREPASSWORD=;VALIDATESERVERCERTIFICATE=true;
> CODEPAGEOVERRIDE=;REFCURSORSUPPORT=true;KEYSTOREPASSWORD=;CO
> NNECTIONRETRYCOUNT=5;SENDFLOATPARAMETERSASSTRING=false;COMMI
> TBEHAVIOR=serverDefault;ENABLEBULKLOAD=false;TNSSERVERNAME=;
> BATCHPERFORMANCEWORKAROUND=false;INITIALIZATIONSTRING=;FAILO
> VERPRECONNECT=false;ENABLESERVERRESULTCACHE=false;RESULTSETM
> ETADATAOPTIONS=0;CLIENTUSER=;QUERYTIMEOUT=0;HOSTNAMEINCERTIF
> ICATE=;FAILOVERGRANULARITY=nonAtomic;WIREPROTOCOLMODE=1;CATA
> LOGINCLUDESSYNONYMS=true;APPLICATIONNAME=;JAVADOUBLETOSTRING
> =false;LOADLIBRARYPATH=;INITIALCOLUMNBUFFERSIZE=-1;IMPORTSTA
> TEMENTPOOL=;ALTERNATESERVERS=;SDUSIZE=;KEYPASSWORD=;ENCRYPTI
> ONMETHOD=NoEncryption;ACCOUNTINGINFO=;CONVERTNULL=1;TRUSTSTO
> RE=;TNSNAMESFILE=;JDBCBEHAVIOR=1;FAILOVERMODE=connect;AUTHEN
> TICATIONMETHOD=auto;LOGINTIMEOUT=0;SERVICENAME=;SERVERTYPE=;
> LOADBALANCING=false;SID=TEST;WORKAROUNDS=0;INSENSITIVERESULT
> SETBUFFERSIZE=2048;SYSLOGINROLE=;CLIENTHOSTNAME=;FETCHTSWTZA
> STIMESTAMP=false)
>
> spy>> DatabaseMetaData[88].getDriverName()
> spy>> OK (Oracle)
>
> spy>> DatabaseMetaData[88].getDriverVersion()
> spy>> OK (4.0.027033 (040328.014805))
>
> spy>> DatabaseMetaData[88].getDatabaseProductName()
> spy>> OK (Oracle)
>
> spy>> DatabaseMetaData[88].getDatabaseProductVersion()
> spy>> OK (11.1.0.6.0)
>
> spy>> Connection Options : spy>> CATALOGOPTIONS=2
> spy>> CONNECTIONRETRYDELAY=1
> spy>> BULKLOADBATCHSIZE=1000
> spy>> SUPPORTLINKS=false
> spy>> MAXPOOLEDSTATEMENTS=0
> spy>> SPYATTRIBUTES=(log=(file)c:\temp\spy_rky.log)
> spy>> KEYSTORE=
> spy>> NEWPASSWORD=
> spy>> STRINGPARAMSMUSTMATCHCHARCOLUMNS=true
> spy>> PROGRAMID=
> spy>> ENABLECANCELTIMEOUT=false
> spy>> TRUSTSTOREPASSWORD=
> spy>> VALIDATESERVERCERTIFICATE=true
> spy>> CODEPAGEOVERRIDE=
> spy>> REFCURSORSUPPORT=true
> spy>> KEYSTOREPASSWORD=
> spy>> CONNECTIONRETRYCOUNT=5
> spy>> SENDFLOATPARAMETERSASSTRING=false
> spy>> COMMITBEHAVIOR=serverDefault
> spy>> ENABLEBULKLOAD=false
> spy>> TNSSERVERNAME=
> spy>> BATCHPERFORMANCEWORKAROUND=false
> spy>> INITIALIZATIONSTRING=
> spy>> FAILOVERPRECONNECT=false
> spy>> ENABLESERVERRESULTCACHE=false
> spy>> RESULTSETMETADATAOPTIONS=0
> spy>> CLIENTUSER=
> spy>> QUERYTIMEOUT=0
> spy>> HOSTNAMEINCERTIFICATE=
> spy>> FAILOVERGRANULARITY=nonAtomic
> spy>> WIREPROTOCOLMODE=1
> spy>> CATALOGINCLUDESSYNONYMS=true
> spy>> APPLICATIONNAME=
> spy>> JAVADOUBLETOSTRING=false
> spy>> LOADLIBRARYPATH=
> spy>> INITIALCOLUMNBUFFERSIZE=-1
> spy>> IMPORTSTATEMENTPOOL=
> spy>> ALTERNATESERVERS=
> spy>> SDUSIZE=
> spy>> KEYPASSWORD=
> spy>> ENCRYPTIONMETHOD=NoEncryption
> spy>> ACCOUNTINGINFO=
> spy>> CONVERTNULL=1
> spy>> TRUSTSTORE=
> spy>> TNSNAMESFILE=
> spy>> JDBCBEHAVIOR=1
> spy>> FAILOVERMODE=connect
> spy>> AUTHENTICATIONMETHOD=auto
> spy>> LOGINTIMEOUT=0
> spy>> SERVICENAME=
> spy>> SERVERTYPE=
> spy>> LOADBALANCING=false
> spy>> SID=TEST
> spy>> WORKAROUNDS=0
> spy>> INSENSITIVERESULTSETBUFFERSIZE=2048
> spy>> SYSLOGINROLE=
> spy>> CLIENTHOSTNAME=
> spy>> FETCHTSWTZASTIMESTAMP=false
> spy>> Driver Name = Oracle
> spy>> Driver Version = 4.0.027033 (040328.014805)
> spy>> Database Name = Oracle
> spy>> Database Version = 11.1.0.6.0
>
> spy>> Connection[19].getMetaData()
> spy>> OK (DatabaseMetaData[89])
>
> spy>> DatabaseMetaData[89].getMaxStatements()
> spy>> OK (0)
>
> spy>> Connection[19].getMetaData()
> spy>> OK (DatabaseMetaData[90])
>
> spy>> DatabaseMetaData[90].getMaxStatements()
> spy>> OK (0)
>
> spy>> Connection[19].getMetaData()
> spy>> OK (DatabaseMetaData[91])
>
> spy>> DatabaseMetaData[91].getMaxStatements()
> spy>> OK (0)
>
> spy>> Connection[19].prepareStatement(String sql)
> spy>> sql = select 'AAA' AS TEST
> from EMP
> spy>> OK (PreparedStatement[18])
>
> spy>> PreparedStatement[18].getConnection()
> spy>> OK (Connection[19])
>
> spy>> Connection[19].getMetaData()
> spy>> OK (DatabaseMetaData[92])
>
> spy>> DatabaseMetaData[92].getDriverName()
> spy>> OK (Oracle)
>
> spy>> PreparedStatement[18].getMetaData()
> spy>> OK (ResultSetMetaData[17])
>
> spy>> ResultSetMetaData[17].getColumnCount()
> spy>> OK (1)
>
> spy>> ResultSetMetaData[17].getColumnCount()
> spy>> OK (1)
>
> spy>> ResultSetMetaData[17].getColumnCount()
> spy>> OK (1)
>
> spy>> ResultSetMetaData[17].getColumnName(int column)
> spy>> column = 1
> spy>> OK (TEST)
>
> spy>> ResultSetMetaData[17].getColumnLabel(int column)
> spy>> column = 1
> spy>> OK (TEST)
>
> spy>> ResultSetMetaData[17].getColumnClassName(int column)
> spy>> column = 1
> spy>> OK (java.lang.String)
>
> spy>> ResultSetMetaData[17].getColumnClassName(int column)
> spy>> column = 1
> spy>> OK (java.lang.String)
>
> spy>> ResultSetMetaData[17].getColumnTypeName(int column)
> spy>> column = 1
> spy>> OK (char)
>
> spy>> PreparedStatement[18].close()
> spy>> OK
>
> spy>> Connection[19].isClosed()
> spy>> OK (false)
>
> spy>> Connection[19].close()
> spy>> OK
>
> spy>> Connection[20].getMetaData()
> spy>> OK (DatabaseMetaData[93])
>
> spy>> DatabaseMetaData[93].getURL()
> spy>> OK (jdbc:rkyoem:oracle://10.80.5.29:1521
> ;CATALOGOPTIONS=2;CONNECTIONRETRYDELAY=1;BULKLOADBATCHSIZE=1
> 000;SUPPORTLINKS=false;MAXPOOLEDSTATEMENTS=0;SPYATTRIBUTES=(
> log=(file)c:\temp\spy_rky.log);KEYSTORE=;NEWPASSWORD=;STRING
> PARAMSMUSTMATCHCHARCOLUMNS=true;PROGRAMID=;ENABLECANCELTIMEO
> UT=false;TRUSTSTOREPASSWORD=;VALIDATESERVERCERTIFICATE=true;
> CODEPAGEOVERRIDE=;REFCURSORSUPPORT=true;KEYSTOREPASSWORD=;CO
> NNECTIONRETRYCOUNT=5;SENDFLOATPARAMETERSASSTRING=false;COMMI
> TBEHAVIOR=serverDefault;ENABLEBULKLOAD=false;TNSSERVERNAME=;
> BATCHPERFORMANCEWORKAROUND=false;INITIALIZATIONSTRING=;FAILO
> VERPRECONNECT=false;ENABLESERVERRESULTCACHE=false;RESULTSETM
> ETADATAOPTIONS=0;CLIENTUSER=;QUERYTIMEOUT=0;HOSTNAMEINCERTIF
> ICATE=;FAILOVERGRANULARITY=nonAtomic;WIREPROTOCOLMODE=1;CATA
> LOGINCLUDESSYNONYMS=true;APPLICATIONNAME=;JAVADOUBLETOSTRING
> =false;LOADLIBRARYPATH=;INITIALCOLUMNBUFFERSIZE=-1;IMPORTSTA
> TEMENTPOOL=;ALTERNATESERVERS=;SDUSIZE=;KEYPASSWORD=;ENCRYPTI
> ONMETHOD=NoEncryption;ACCOUNTINGINFO=;CONVERTNULL=1;TRUSTSTO
> RE=;TNSNAMESFILE=;JDBCBEHAVIOR=1;FAILOVERMODE=connect;AUTHEN
> TICATIONMETHOD=auto;LOGINTIMEOUT=0;SERVICENAME=;SERVERTYPE=;
> LOADBALANCING=false;SID=ORCL;WORKAROUNDS=0;INSENSITIVERESULT
> SETBUFFERSIZE=2048;SYSLOGINROLE=;CLIENTHOSTNAME=;FETCHTSWTZA
> STIMESTAMP=false)
>
> spy>> DatabaseMetaData[93].getDriverName()
> spy>> OK (Oracle)
>
> spy>> DatabaseMetaData[93].getDriverVersion()
> spy>> OK (4.0.027033 (040328.014805))
>
> spy>> DatabaseMetaData[93].getDatabaseProductName()
> spy>> OK (Oracle)
>
> spy>> DatabaseMetaData[93].getDatabaseProductVersion()
> spy>> OK (11.1.0.6.0)
>
> spy>> Connection Options : spy>> CATALOGOPTIONS=2
> spy>> CONNECTIONRETRYDELAY=1
> spy>> BULKLOADBATCHSIZE=1000
> spy>> SUPPORTLINKS=false
> spy>> MAXPOOLEDSTATEMENTS=0
> spy>> SPYATTRIBUTES=(log=(file)c:\temp\spy_rky.log)
> spy>> KEYSTORE=
> spy>> NEWPASSWORD=
> spy>> STRINGPARAMSMUSTMATCHCHARCOLUMNS=true
> spy>> PROGRAMID=
> spy>> ENABLECANCELTIMEOUT=false
> spy>> TRUSTSTOREPASSWORD=
> spy>> VALIDATESERVERCERTIFICATE=true
> spy>> CODEPAGEOVERRIDE=
> spy>> REFCURSORSUPPORT=true
> spy>> KEYSTOREPASSWORD=
> spy>> CONNECTIONRETRYCOUNT=5
> spy>> SENDFLOATPARAMETERSASSTRING=false
> spy>> COMMITBEHAVIOR=serverDefault
> spy>> ENABLEBULKLOAD=false
> spy>> TNSSERVERNAME=
> spy>> BATCHPERFORMANCEWORKAROUND=false
> spy>> INITIALIZATIONSTRING=
> spy>> FAILOVERPRECONNECT=false
> spy>> ENABLESERVERRESULTCACHE=false
> spy>> RESULTSETMETADATAOPTIONS=0
> spy>> CLIENTUSER=
> spy>> QUERYTIMEOUT=0
> spy>> HOSTNAMEINCERTIFICATE=
> spy>> FAILOVERGRANULARITY=nonAtomic
> spy>> WIREPROTOCOLMODE=1
> spy>> CATALOGINCLUDESSYNONYMS=true
> spy>> APPLICATIONNAME=
> spy>> JAVADOUBLETOSTRING=false
> spy>> LOADLIBRARYPATH=
> spy>> INITIALCOLUMNBUFFERSIZE=-1
> spy>> IMPORTSTATEMENTPOOL=
> spy>> ALTERNATESERVERS=
> spy>> SDUSIZE=
> spy>> KEYPASSWORD=
> spy>> ENCRYPTIONMETHOD=NoEncryption
> spy>> ACCOUNTINGINFO=
> spy>> CONVERTNULL=1
> spy>> TRUSTSTORE=
> spy>> TNSNAMESFILE=
> spy>> JDBCBEHAVIOR=1
> spy>> FAILOVERMODE=connect
> spy>> AUTHENTICATIONMETHOD=auto
> spy>> LOGINTIMEOUT=0
> spy>> SERVICENAME=
> spy>> SERVERTYPE=
> spy>> LOADBALANCING=false
> spy>> SID=ORCL
> spy>> WORKAROUNDS=0
> spy>> INSENSITIVERESULTSETBUFFERSIZE=2048
> spy>> SYSLOGINROLE=
> spy>> CLIENTHOSTNAME=
> spy>> FETCHTSWTZASTIMESTAMP=false
> spy>> Driver Name = Oracle
> spy>> Driver Version = 4.0.027033 (040328.014805)
> spy>> Database Name = Oracle
> spy>> Database Version = 11.1.0.6.0
>
> spy>> Connection[20].getMetaData()
> spy>> OK (DatabaseMetaData[94])
>
> spy>> DatabaseMetaData[94].getMaxStatements()
> spy>> OK (0)
>
> spy>> Connection[20].getMetaData()
> spy>> OK (DatabaseMetaData[95])
>
> spy>> DatabaseMetaData[95].getMaxStatements()
> spy>> OK (0)
>
> spy>> Connection[20].getMetaData()
> spy>> OK (DatabaseMetaData[96])
>
> spy>> DatabaseMetaData[96].getMaxStatements()
> spy>> OK (0)
>
> spy>> Connection[20].prepareStatement(String sql)
> spy>> sql = select 'AAA' AS ORCL
> from DEPT
> spy>> OK (PreparedStatement[19])
>
> spy>> PreparedStatement[19].getConnection()
> spy>> OK (Connection[20])
>
> spy>> Connection[20].getMetaData()
> spy>> OK (DatabaseMetaData[97])
>
> spy>> DatabaseMetaData[97].getDriverName()
> spy>> OK (Oracle)
>
> spy>> PreparedStatement[19].getMetaData()
> spy>> OK (ResultSetMetaData[18])
>
> spy>> ResultSetMetaData[18].getColumnCount()
> spy>> OK (1)
>
> spy>> ResultSetMetaData[18].getColumnCount()
> spy>> OK (1)
>
> spy>> ResultSetMetaData[18].getColumnCount()
> spy>> OK (1)
>
> spy>> ResultSetMetaData[18].getColumnName(int column)
> spy>> column = 1
> spy>> OK (ORCL)
>
> spy>> ResultSetMetaData[18].getColumnLabel(int column)
> spy>> column = 1
> spy>> OK (ORCL)
>
> spy>> ResultSetMetaData[18].getColumnClassName(int column)
> spy>> column = 1
> spy>> OK (java.lang.String)
>
> spy>> ResultSetMetaData[18].getColumnClassName(int column)
> spy>> column = 1
> spy>> OK (java.lang.String)
>
> spy>> ResultSetMetaData[18].getColumnTypeName(int column)
> spy>> column = 1
> spy>> OK (char)
>
> spy>> Connection[20].isClosed()
> spy>> OK (false)
>
> spy>> Connection[20].close()
> spy>> OK
>
> spy>> Connection[21].getMetaData()
> spy>> OK (DatabaseMetaData[98])
>
> spy>> DatabaseMetaData[98].getURL()
> spy>> OK (jdbc:rkyoem:oracle://10.80.5.29:1521
> ;CATALOGOPTIONS=2;CONNECTIONRETRYDELAY=1;BULKLOADBATCHSIZE=1
> 000;SUPPORTLINKS=false;MAXPOOLEDSTATEMENTS=0;SPYATTRIBUTES=(
> log=(file)c:\temp\spy_rky.log);KEYSTORE=;NEWPASSWORD=;STRING
> PARAMSMUSTMATCHCHARCOLUMNS=true;PROGRAMID=;ENABLECANCELTIMEO
> UT=false;TRUSTSTOREPASSWORD=;VALIDATESERVERCERTIFICATE=true;
> CODEPAGEOVERRIDE=;REFCURSORSUPPORT=true;KEYSTOREPASSWORD=;CO
> NNECTIONRETRYCOUNT=5;SENDFLOATPARAMETERSASSTRING=false;COMMI
> TBEHAVIOR=serverDefault;ENABLEBULKLOAD=false;TNSSERVERNAME=;
> BATCHPERFORMANCEWORKAROUND=false;INITIALIZATIONSTRING=;FAILO
> VERPRECONNECT=false;ENABLESERVERRESULTCACHE=false;RESULTSETM
> ETADATAOPTIONS=0;CLIENTUSER=;QUERYTIMEOUT=0;HOSTNAMEINCERTIF
> ICATE=;FAILOVERGRANULARITY=nonAtomic;WIREPROTOCOLMODE=1;CATA
> LOGINCLUDESSYNONYMS=true;APPLICATIONNAME=;JAVADOUBLETOSTRING
> =false;LOADLIBRARYPATH=;INITIALCOLUMNBUFFERSIZE=-1;IMPORTSTA
> TEMENTPOOL=;ALTERNATESERVERS=;SDUSIZE=;KEYPASSWORD=;ENCRYPTI
> ONMETHOD=NoEncryption;ACCOUNTINGINFO=;CONVERTNULL=1;TRUSTSTO
> RE=;TNSNAMESFILE=;JDBCBEHAVIOR=1;FAILOVERMODE=connect;AUTHEN
> TICATIONMETHOD=auto;LOGINTIMEOUT=0;SERVICENAME=;SERVERTYPE=;
> LOADBALANCING=false;SID=TEST;WORKAROUNDS=0;INSENSITIVERESULT
> SETBUFFERSIZE=2048;SYSLOGINROLE=;CLIENTHOSTNAME=;FETCHTSWTZA
> STIMESTAMP=false)
>
> spy>> DatabaseMetaData[98].getDriverName()
> spy>> OK (Oracle)
>
> spy>> DatabaseMetaData[98].getDriverVersion()
> spy>> OK (4.0.027033 (040328.014805))
>
> spy>> DatabaseMetaData[98].getDatabaseProductName()
> spy>> OK (Oracle)
>
> spy>> DatabaseMetaData[98].getDatabaseProductVersion()
> spy>> OK (11.1.0.6.0)
>
> spy>> Connection Options : spy>> CATALOGOPTIONS=2
> spy>> CONNECTIONRETRYDELAY=1
> spy>> BULKLOADBATCHSIZE=1000
> spy>> SUPPORTLINKS=false
> spy>> MAXPOOLEDSTATEMENTS=0
> spy>> SPYATTRIBUTES=(log=(file)c:\temp\spy_rky.log)
> spy>> KEYSTORE=
> spy>> NEWPASSWORD=
> spy>> STRINGPARAMSMUSTMATCHCHARCOLUMNS=true
> spy>> PROGRAMID=
> spy>> ENABLECANCELTIMEOUT=false
> spy>> TRUSTSTOREPASSWORD=
> spy>> VALIDATESERVERCERTIFICATE=true
> spy>> CODEPAGEOVERRIDE=
> spy>> REFCURSORSUPPORT=true
> spy>> KEYSTOREPASSWORD=
> spy>> CONNECTIONRETRYCOUNT=5
> spy>> SENDFLOATPARAMETERSASSTRING=false
> spy>> COMMITBEHAVIOR=serverDefault
> spy>> ENABLEBULKLOAD=false
> spy>> TNSSERVERNAME=
> spy>> BATCHPERFORMANCEWORKAROUND=false
> spy>> INITIALIZATIONSTRING=
> spy>> FAILOVERPRECONNECT=false
> spy>> ENABLESERVERRESULTCACHE=false
> spy>> RESULTSETMETADATAOPTIONS=0
> spy>> CLIENTUSER=
> spy>> QUERYTIMEOUT=0
> spy>> HOSTNAMEINCERTIFICATE=
> spy>> FAILOVERGRANULARITY=nonAtomic
> spy>> WIREPROTOCOLMODE=1
> spy>> CATALOGINCLUDESSYNONYMS=true
> spy>> APPLICATIONNAME=
> spy>> JAVADOUBLETOSTRING=false
> spy>> LOADLIBRARYPATH=
> spy>> INITIALCOLUMNBUFFERSIZE=-1
> spy>> IMPORTSTATEMENTPOOL=
> spy>> ALTERNATESERVERS=
> spy>> SDUSIZE=
> spy>> KEYPASSWORD=
> spy>> ENCRYPTIONMETHOD=NoEncryption
> spy>> ACCOUNTINGINFO=
> spy>> CONVERTNULL=1
> spy>> TRUSTSTORE=
> spy>> TNSNAMESFILE=
> spy>> JDBCBEHAVIOR=1
> spy>> FAILOVERMODE=connect
> spy>> AUTHENTICATIONMETHOD=auto
> spy>> LOGINTIMEOUT=0
> spy>> SERVICENAME=
> spy>> SERVERTYPE=
> spy>> LOADBALANCING=false
> spy>> SID=TEST
> spy>> WORKAROUNDS=0
> spy>> INSENSITIVERESULTSETBUFFERSIZE=2048
> spy>> SYSLOGINROLE=
> spy>> CLIENTHOSTNAME=
> spy>> FETCHTSWTZASTIMESTAMP=false
> spy>> Driver Name = Oracle
> spy>> Driver Version = 4.0.027033 (040328.014805)
> spy>> Database Name = Oracle
> spy>> Database Version = 11.1.0.6.0
>
> spy>> Connection[21].getMetaData()
> spy>> OK (DatabaseMetaData[99])
>
> spy>> DatabaseMetaData[99].getMaxStatements()
> spy>> OK (0)
>
> spy>> Connection[21].getMetaData()
> spy>> OK (DatabaseMetaData[100])
>
> spy>> DatabaseMetaData[100].getMaxStatements()
> spy>> OK (0)
>
> spy>> Connection[21].getMetaData()
> spy>> OK (DatabaseMetaData[101])
>
> spy>> DatabaseMetaData[101].getMaxStatements()
> spy>> OK (0)
>
> spy>> Connection[21].prepareStatement(String sql)
> spy>> sql = select 'AAA' AS TEST
> from EMP
> spy>> OK (PreparedStatement[20])
>
> spy>> PreparedStatement[20].getConnection()
> spy>> OK (Connection[21])
>
> spy>> Connection[21].getMetaData()
> spy>> OK (DatabaseMetaData[102])
>
> spy>> DatabaseMetaData[102].getDriverName()
> spy>> OK (Oracle)
>
> spy>> PreparedStatement[20].getMetaData()
> spy>> OK (ResultSetMetaData[19])
>
> spy>> ResultSetMetaData[19].getColumnCount()
> spy>> OK (1)
>
> spy>> ResultSetMetaData[19].getColumnCount()
> spy>> OK (1)
>
> spy>> ResultSetMetaData[19].getColumnCount()
> spy>> OK (1)
>
> spy>> ResultSetMetaData[19].getColumnName(int column)
> spy>> column = 1
> spy>> OK (TEST)
>
> spy>> ResultSetMetaData[19].getColumnLabel(int column)
> spy>> column = 1
> spy>> OK (TEST)
>
> spy>> ResultSetMetaData[19].getColumnClassName(int column)
> spy>> column = 1
> spy>> OK (java.lang.String)
>
> spy>> ResultSetMetaData[19].getColumnClassName(int column)
> spy>> column = 1
> spy>> OK (java.lang.String)
>
> spy>> ResultSetMetaData[19].getColumnTypeName(int column)
> spy>> column = 1
> spy>> OK (char)
>
> spy>> PreparedStatement[20].close()
> spy>> OK
>
Re: java.sql.Statement has been closed strangely when inner joining 2 datasets [message #553869 is a reply to message #553746] Thu, 19 August 2010 09:05 Go to previous messageGo to next message
Ricky  is currently offline Ricky Friend
Messages: 9
Registered: June 2010
Junior Member
Thank you jason.

I finally found the issue exists in our extension. Your guess was right. I do not know why the spy log was ok yesterday but has exception today. From the new log, there is a connection was closed sometime by our code but later birt used the statement created by the closed connection. That's the reason. The database-provided drivers not having his problem are because they are not integrated with our plugin(extension).

We explicitly close the connection in our code.
We have a class in our extension which implements org.eclipse.birt.report.data.oda.jdbc.IConnectionFactory.
The getConnection method is coded below:
// Check if the connection is open
if (i_connection != null && !i_connection.isClosed())
{
// We need to close the connection as it causes problems at times
c_log.info(" Closing connection object ");
i_connection.close();//We explicitly close the connection here, but someone add a comment saying this should be done. I need to investigate why he did this. Do you have any suggestion?
}

// Establish a connection
createConnection(driverClass, url, connectionProperties);

if (c_log.isInfoEnabled())
{
c_log.info("Established connection to the Oracle server : "
+ i_connection);
}
return i_conection;
}

-Ricky

[Updated on: Thu, 19 August 2010 09:09]

Report message to a moderator

Re: java.sql.Statement has been closed strangely when inner joining 2 datasets [message #553980 is a reply to message #553869] Thu, 19 August 2010 14:53 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Glad to hear.

On 8/19/2010 5:05 AM, Ricky wrote:
> Thank you jason.
> I finally found the issue exists in our extension. Your guess was right.
> I do not know why the spy log was ok yesterday but has exception today.
> From the log, there is a connection was closed sometime by our code but
> later birt used the statement created by the closed connection. That's
> reason. The database-provided drivers not having his problem are because
> they are not integrated with our plugin(extension).
>
> We explicitly close the connection in our code.
> We have a class in our extension which implements
> org.eclipse.birt.report.data.oda.jdbc.IConnectionFactory.
> The getConnection method is coded below:
> // Check if the connection is open
> if (i_connection != null && !i_connection.isClosed())
> {
> // We need to close the connection as it causes problems at times
> c_log.info(" Closing connection object ");
> i_connection.close();//We explicitly close the connection here, but
> someone add a comment saying this should be done. I need to investigate
> why he did this.
> }
>
> // Establish a connection
> createConnection(driverClass, url, connectionProperties);
>
> if (c_log.isInfoEnabled())
> {
> c_log.info("Established connection to the Oracle server : "
> + i_connection);
> }
> return i_conection;
> }
>
> -Ricky
Previous Topic:Birt Viewer 2.6.0 on Websphere 6.1.0.29
Next Topic:Editing Birt xls prototype emitter
Goto Forum:
  


Current Time: Sun Nov 23 21:37:33 GMT 2014

Powered by FUDForum. Page generated in 0.02824 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software