[gatein-dev] GateIn on oracle DB
Michal Vančo
mvanco at redhat.com
Thu Mar 11 06:35:56 EST 2010
Nicolas Filotto wrote:
>
>
> On Thu, Mar 11, 2010 at 9:57 AM, Michal Vančo <mvanco at redhat.com>
> wrote:
> Hi,
>
> today I checked following situations with oracle10:
> - oracle11 driver for oracle10 db
> - create bundle with JCR 1.12.0-GA
> - delete gatein-sample* in server/default/deploy -> only
> change was
> that it failed with: Cannot create the portal container
> 'portal', before
> it was: Cannot create the portal container 'sample-portal' and
> Cannot
> create the portal container 'portal'
> - creating jcr tables manually with script:
> http://anonsvn.jboss.org/repos/exo-jcr/jcr/tags/1.12.0-GA/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.ora.sql
>
> didn't help, but after adding script to create JCR_CONFIG
> table -> it
> started to work (detail of script in another mail on
> gatein-dev)
>
> So, looks like JCR don't want to initialize. Any suggestions
> why?
> So far the only thing that we know is that
> con.getMetaData().getTables(null, null, "JCR_CONFIG", null); returns a
> result, so the JCR assumes that the table exists and thus try to
> launch a query on it so it fails since actually the table doesn't
> exist.
> So far, we don't know why this method returns something on your side,
> can you add a breakpoint on the method
> org.exoplatform.services.jcr.impl.config.JDBCConfigurationPersister.isDbInitialized() of the project exo.jcr.component.core and tell us what you have in your resultset?
when calling
ResultSet trs = con.getMetaData().getTables(null, null, "JCR_CONFIG", null);
return trs.next();
it returns true and content of trs variable from debug is attached.
Then it ends on line 237: ResultSet res = ps.executeQuery();
Is it enough? Or what more can I explore in debug?
>
> Michal
>
>
> Michal Vančo wrote:
> > Hi,
> >
> > Nicolas Filotto wrote:
> > > Could you please provide the list of tables that you can
> see with your
> > > credentials on oracle 10 G?
> >
> > As I wrote yesterday in my additional reply:
> > I'm using sqldeveloper tool to see the content of oracle DB,
> and at all
> > oracle10 cases, I can't see that anything is created
> (tables, sequence,
> > indexes...) in JCR schema. Only IDM schema initialization is
> done.
> >
> > >
> > > On Wed, Mar 10, 2010 at 8:41 PM, Michal Vančo
> <mvanco at redhat.com>
> > > wrote:
> > > Hi,
> > >
> > > currently I have same results as before (table or
> view does
> > > not exist)
> > > on oracle10 in these conditions:
> > > - 2 datasources on one machine (differentiated by
> user names)
> > > - 1 datasource on a machine (JCR and IDM
> together)
> > > - 2 datasources on separate machines
> >
> > It was added for these cases ^.
> >
> > >
> > > To run GateIn trunk on Oracle10, I do following
> steps:
> > > - prepare GateIn trunk bundle
> > > - unzip bundle
> > > - change driver class, url, user and password in
> > > jcr-configuration.xml
> > >
> in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/
> > > - change driver class, url, user and password in
> > > idm-configuration.xml
> > >
> in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/organization/
> > > - add <property name="hibernate.hbm2ddl.auto"
> > > value="create-drop"/> in
> > > idm-configuration.xml
> > > - copy oracle10 jdbc driver
> into ../server/default/lib
> > > - start gatein by run.sh in bin folder
> > >
> > > (I can provide a script from hudson where you can
> add your own
> > > paths and
> > > credentials...)
> > >
> > > For oracle11:
> > > - when run with same config as on oracle10, I get
> error:
> > > ORA-00972: identifier is too long (when
> initializing
> > >
> org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl)
> > >
> > > - oracle11_jcr.jpg - screen of what has been
> created in DB
> > >
> > > - if I edit table names
> > >
> in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/repository-configuration.xml, gatein started correctly
> > > - oracle11_jcr_shorten_names.jpg - screen of what
> has been
> > > created in DB
> > >
> > > Let me know if you need more details to reproduce
> it on your
> > > side.
> > >
> > > Best regards,
> > >
> > > Michal
> > >
> > >
> > > Nicolas Filotto píše v St 10. 03. 2010 v 17:39
> +0100:
> > >
> > > >
> > > >
> > > > On Wed, Mar 10, 2010 at 5:19 PM, Prabhat Jha
> > > <pjha at redhat.com> wrote:
> > > > I have created
> > > https://jira.jboss.org/jira/browse/EXOJCR-582
> > > > for oracle11 issue. Please check that I
> have right
> > > affects and
> > > > fix versions.
> > > >
> > > > thx, FYI I've just set the right settings
> > > >
> > > > The version of GateIn and JCR is the one
> that's in
> > > GateIn
> > > > trunk currently. The way our environment
> is setup is
> > > that we
> > > > have one Oracle10 DB servers and
> different usernames
> > > which I
> > > > believe means different schemas in
> Oracle for
> > > different tests
> > > > (gatein-ui, gatein-jcr etc) configured
> on that
> > > server. I would
> > > > have to wait for Michal to show up for
> info. He
> > > needed to
> > > > attend to some personal stuff : hospital
> to check on
> > > his mom.
> > > >
> > > > But in your environment, you have GateIn
> starting
> > > fine on
> > > > Oracle 10, right?
> > > >
> > > > no so far, we have only tested with pure JCR but
> in the same
> > > > conditions as gatein, now as we know the version
> of gatein
> > > we will try
> > > > with the same version (i.e the trunk)
> > > >
> > > > thanks,
> > > > prabhat
> > > >
> > > >
> > > >
> > > >
> > > > ----- "Nicolas Filotto"
> <nicolas.filotto at gmail.com>
> > > wrote:
> > > > > Prabhat and/or Michal, could you
> please provide
> > > the answers
> > > > of the questions asked by Peter and me.
> We cannot
> > > reproduce so
> > > > far, so we need your help. Please note
> that we
> > > blocked the
> > > > release of GA because of this last
> issue, so we need
> > > your help
> > > > to fix it asap.
> > > > >
> > > > >
> > > > Thank you in advance,
> > > > BR,
> > > > Nicolas
> > > > >
> > > > > On Wed, Mar 10, 2010 at 3:02 PM,
> Nicolas Filotto
> > > > <nicolas.filotto at gmail.com> wrote:
> > > > >
> > > > Hi Prabhat,
> > > > >
> > > > >
> > > > my comments inline
> > > > >
> > > > >
> > > > > On Wed, Mar 10, 2010 at 2:01
> PM, Prabhat
> > > Jha
> > > > <pjha at redhat.com> wrote:
> > > > >
> > > > >
> > > > > Hi Nicolas,
> > > > >
> > > > > Yes, a jira is on the
> way but way
> > > to
> > > > reproduce this problem
> is quite
> > > simple. You
> > > > start with a clean
> Oracle 10
> > > database instance
> > > > and see the problem
> during startup.
> > > It would
> > > > make sense to have this
> issue solved
> > > or have a
> > > > work around before
> GateIn GA.
> > > > >
> > > > It is not enough, we need to
> know, which
> > > exact version
> > > > of eXo JCR and GateIn, you are
> using and the
> > > content
> > > > of the files that you modified.
> > > > could you please open a
> connexion with the
> > > same
> > > > account and give us the list of
> tables that
> > > you can
> > > > see
> > > > >
> > > > >
> > > > > Quick questions:
> > > > > As per oracle11
> finding, is JCR
> > > config
> > > > (table names) going to
> be updated
> > > across the
> > > > board?
> > > > >
> > > > You mean to change the sql
> scripts for
> > > oracle 11G? If
> > > > so please create a JIRA, it will
> be done in
> > > the next
> > > > maintenance version of eXo JCR
> which will be
> > > 1.12.1 GA
> > > > planned for the end of March
> > > > >
> > > > > Also, I am wondiering
> given that
> > > Oracle 10
> > > > has been around for a
> while, I am
> > > wondering
> > > > what has changed in the
> latest JCR
> > > that it
> > > > does not work here. Did
> the last GA
> > > version
> > > > work?
> > > > >
> > > > Hard to say before reproducing
> your bug
> > > >
> > > > >
> > > > >
> > > > > Thanks,
> > > > > Prabhat
> > > >
> > > >
> > > > >
> > > > >
> > > > >
> > > > > ----- "Nicolas
> Filotto"
> > > >
> <nicolas.filotto at gmail.com> wrote:
> > > > > > Hi Michal, could you
> please
> > > create JIRA
> > > > issues in the eXo JCR
> project
> > > >
> > > (https://jira.jboss.org/jira/browse/EXOJCR)
> > > > with all the information
> needed to
> > > allow us to
> > > > reproduce?
> > > > > >
> > > > > >
> > > > > > On Wed, Mar 10, 2010
> at 1:46 PM,
> > > Nicolas
> > > > Filotto
> <nicolas.filotto at gmail.com>
> > > wrote:
> > > > > >
> > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > On Wed, Mar
> 10, 2010 at
> > > 1:29 PM,
> > > > Michal Vančo
> > > <mvanco at redhat.com>
> > > > wrote:
> > > > > >
> > > > Hi,
> > > > > >
> > > > > >
> oracle11 now
> > > works,
> > > > oracle10
> not. See
> > > below...
> > > > > >
> > > > > >
> Peter Nedonosko
> > > wrote
> > > > > >
> > > > > Hi,
> > > > > > >
> > > > > > >
> about Oracle
> > > 10 and '
> > > > table or
> view does
> > > not exist':
> > > > > > >
> the problem is
> > > possible
> > > > if
> addConfig used in
> > > > > > >
> > > >
> > >
> org.exoplatform.services.jcr.config.RepositoryServiceConfiguration
> > > > > > > (I
> found it in
> > > portal
> > > > \trunk
> \examples
> > > \portal\war\src
> > > > \main
> \webapp\WEB-INF
> > > \conf
> > > >
> \sample-portal\jcr
> > > >
> > > \jcr-configuration.xml)
> > > > > >
> > > > > >
> > > > What you
> meant with
> > > addConfig
> > > > plugin?
> > > > > >
> Should I add
> > > >
> > > <set-method>addConfig</set-method> in
> > > > > >
> > > jcr-configuration.xml?
> > > > > > Or
> how can I
> > > solve 'table
> > > > or view
> does not
> > > exist' on
> > > >
> oracle10?
> > > > > >
> > > >
> > > > > >
> > > > I guess it is
> not related
> > > since it
> > > > works with other
> databases
> > > >
> > > > >
> > > >
> > > > > > >
> > > > > > > if
> the
> > > database is
> > > > creating
> from the
> > > scratch and
> > > > if the
> configuration
> > > > > > >
> persister got
> > > an answer
> > > > from the
> Oracle -
> > > your table
> > > > exists
> in
> > > > > > >
> > > isDbInitialized():
> > > > > > >
> ResultSet trs
> > > =
> > > >
> > > con.getMetaData().getTables(null, null,
> configTableName,
> > > null);
> > > > > > >
> return
> > > trs.next(); //
> > > > true =
> yes
> > > > > > >
> > > > > > >
> but then
> > > Oracle fails
> > > > with
> > > > > > >
> > > PreparedStatement ps =
> > > >
> > > con.prepareStatement("SELECT
> > > > COUNT(*)
> FROM " +
> > > > > > >
> > > configTableName + "
> > > > WHERE
> NAME=?");
> > > > > > >
> > > ps.executeQuery(); //
> > > > here
> > > > > > >
> > > > > > >
> but I have to
> > > reproduce
> > > > it
> first...
> > > > > > >
> does Oracle 10
> > > and 11
> > > > runs on
> clean
> > > database from
> > > > the
> start?
> > > > > > > or
> just
> > > restarted on
> > > > existing
> db for
> > > Oracle 11?
> > > > > >
> > > > > >
> > > > Always
> on clean DBs.
> > > > > >
> > > >
> > > > > > >
> > > > > > >
> about
> > > Oracle11:
> > > > > > >
> seems it's
> > > related to
> > > >
> JBossCache loader,
> > > it creates
> > > > a table
> longer of
> > > > > > > 30
> symbols
> > > (ORA-00972:
> > > >
> identifier is too
> > > long).
> > > > > > >
> Why it's not a
> > > problem
> > > > for
> Oracle10 or why
> > > JBossCache
> > > > acts in
> > > > > > >
> different way
> > > on
> > > > Oracle10
> or etc...
> > > > > > >
> try to fix the
> > > problem
> > > > with
> shorten table
> > > name from
> > > >
> > > repository-configuration.xml
> > > > > > >
> e.g.
> > > > > > >
> <property
> > > >
> > > name="jbosscache-cl-cache.jdbc.table.name"
> > > value="lock_portalsys" />
> > > > > > >
> instead of
> > > > > > >
> <property
> > > >
> > > name="jbosscache-cl-cache.jdbc.table.name"
> > > > > > >
> > > >
> > > value="jcrlock_portal_system" />
> > > > > > > it
> should
> > > helps.
> > > > > >
> > > > > >
> > > > I
> shortened all
> > > table names in
> > > >
> > > repository-configuration.xml
> > > > and
> GateIn
> > > > > > on
> Oracle11
> > > started
> > > > without
> "identifier
> > > is too
> > > > long"
> error.
> > > > > >
> > > > > >
> There is job
> > > when it
> > > > starts
> for the first
> > > time:
> > > > > >
> > > >
> > >
> http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5_oracle11/35/
> > > > > >
> > > > > > I
> think that it
> > > would be
> > > > better
> to edit
> > > configuration,
> > > > because
> editing
> > > > > >
> table names
> > > before running
> > > > gatein
> isn't a good
> > > way.
> > > > > >
> > > >
> > > >
> > > > > > >
> > > > > > >
> Regards,
> > > > > > >
> Peter
> > > > > > >
> > > > > > >
> > > > > > > On
> Tue, Mar 9,
> > > 2010 at
> > > > 11:24
> AM, Michal
> > > Vančo
> > > >
> <mvanco at redhat.com>
> > > wrote:
> > > > > > > >
> Yes Bolek,
> > > that's
> > > > true.
> > > > > > > >
> I can't
> > > explain myself
> > > > the job
> in hudson on
> > > EPP5
> > > >
> > > (epp_ui_selenium_tests_oracle10):
> > > > > > > >
> Because
> > > there was same
> > > > problem
> - table or
> > > view does
> > > > not
> exist (build
> > > > > > > >
> #3), builds
> > > #5 and #7
> > > > were OK
> (GateIn
> > > started with
> > > > no
> errors) and
> > > > > > > >
> following
> > > builds again
> > > > failed
> due the same
> > > problem as
> > > > before.
> > > > > > > >
> > > > > > > >
> Regards,
> > > > > > > >
> Michal
> > > > > > > >
> > > > > > > >
> Boleslaw
> > > Dawidowicz
> > > > píše v
> Út 09. 03.
> > > 2010 v 09:59
> > > > +0100:
> > > > > > > >>
> From
> > > mentioned logs
> > > > it looks
> like those
> > > errors
> > > > don't
> come from IDM.
> > > I
> > > > > > > >>
> think the
> > > stack trace
> > > > in all
> cases goes
> > > via
> > > > > > > >>
> > > >
> > > "org.exoplatform.services.jcr.impl.*"
> > > > > > > >>
> > > > > > > >>
> Bolek
> > > > > > > >>
> > > > > > > >>
> On
> > > 03/09/2010 09:15
> > > > AM,
> Michal Vančo
> > > wrote:
> > > > > > > >>
> > Hi,
> > > > > > > >>
> >
> > > > > > > >>
> > I'm
> > > dealing with
> > > > problem
> to start
> > > GateIn with
> > > > Oracle
> DB.
> > > > > > > >>
> > I always
> > > start with
> > > > clean DB
> and use 2
> > > datasource
> > > >
> instances (JCR,
> > > IDM).
> > > > > > > >>
> >
> > > > > > > >>
> > There are
> > > 2
> > > >
> different issues:
> > > > > > > >>
> > Oracle10:
> > > > > > > >>
> > -
> > > ORA-00942: table
> > > > or view
> does not
> > > exist (start
> > > > on
> > > > > > > >>
> >
> > > >
> > >
> org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl at b2ecc0)
> > > > > > > >>
> > - only
> > > IDM schema
> > > > is
> initialized, JCR
> > > not
> > > > > > > >>
> >
> > > > > > > >>
> > Oracle11:
> > > > > > > >>
> > -
> > > ORA-00972:
> > > >
> identifier is too
> > > long (Cannot
> > > >
> instantiate
> > > component class
> > > > > > > >>
> >
> > > >
> > >
> org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl)
> > > > > > > >>
> > - both
> > > schemas are
> > > > created
> (IDM + JCR)
> > > > > > > >>
> >
> > > > > > > >>
> > To run on
> > > oracle, I
> > > > change
> configuration
> > > in
> > > >
> > > idm-configuration.xml and
> > > > > > > >>
> >
> > > >
> > > jcr-configuration.xml, then
> > > > copy
> jdbc driver and
> > > start.
> > > > > > > >>
> > I also
> > > add<property
> > > >
> > > name="hibernate.hbm2ddl.auto"
> > > >
> > > value="create-drop"/>
> > > > > > > >>
> > to
> > > >
> > > idm-configuration.xml
> > > >
> (recommended by
> > > Boleslaw
> > > >
> Dawidowicz - it
> > > worked
> > > > > > > >>
> > on EPP,
> > > but not on
> > > > GateIn
> trunk).
> > > > > > > >>
> >
> > > > > > > >>
> > There are
> > > links to
> > > > log:
> > > > > > > >>
> >
> > > >
> > >
> http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5_oracle10/22/console
> > > > > > > >>
> >
> > > > > > > >>
> >
> > > >
> > >
> http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5_oracle11/21/console
> > > > > > > >>
> >
> > > > > > > >>
> >
> > > > > > > >>
> > I would
> > > appreciate
> > > > any
> help.
> > > > > > > >>
> >
> > > > > > > >>
> > Thanks in
> > > advance
> > > > > > > >>
> > Michal
> > > Vanco
> > > > > > > >>
> >
> > > > > > > >>
> >
> > > >
> > > _______________________________________________
> > > > > > > >>
> >
> > > gatein-dev mailing
> > > > list
> > > > > > > >>
> >
> > > >
> > > gatein-dev at lists.jboss.org
> > > > > > > >>
> >
> > > >
> > >
> https://lists.jboss.org/mailman/listinfo/gatein-dev
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > >
> > > _______________________________________________
> > > > > > > >
> gatein-dev
> > > mailing
> > > > list
> > > > > > > >
> > > >
> > > gatein-dev at lists.jboss.org
> > > > > > > >
> > > >
> > >
> https://lists.jboss.org/mailman/listinfo/gatein-dev
> > > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > Thanks,
> > > > > >
> Michal
> > > > > >
> > > >
> > > >
> > > > > >
> > > >
> > > _______________________________________________
> > > > > >
> gatein-dev
> > > mailing list
> > > > > >
> > > gatein-dev at lists.jboss.org
> > > > > >
> > > >
> > >
> https://lists.jboss.org/mailman/listinfo/gatein-dev
> > > > > >
> > > >
> > > > > >
> > > >
> > > > > > --
> > > > > >
> > > >
> > > > > Nicolas
> Filotto
> > > > > > JCR Product
> Manager
> > > > > > Project
> Manager
> > > > > > eXo Platform
> SAS
> > > > > >
> > > nicolas.filotto at exoplatform.com
> > > > > > +33 (0)6 31
> 32 92 19
> > > > > >
> > > >
> > > > > >
> > > >
> > > > > > --
> > > > > > Nicolas Filotto
> > > > > > JCR Product Manager
> > > > > > Project Manager
> > > > > > eXo Platform SAS
> > > > > >
> nicolas.filotto at exoplatform.com
> > > > > > +33 (0)6 31 32 92 19
> > > > > >
> > > > >
> > > > >
> > > >
> > > _______________________________________________
> gatein-dev
> > > mailing list gatein-dev at lists.jboss.org
> > >
> https://lists.jboss.org/mailman/listinfo/gatein-dev
> > > >
> > > > >
> > > > >
> > > >
> > > > > --
> > > > > Nicolas Filotto
> > > > > JCR Product Manager
> > > > > Project Manager
> > > > > eXo Platform SAS
> > > > >
> nicolas.filotto at exoplatform.com
> > > > > +33 (0)6 31 32 92 19
> > > > >
> > > >
> > > > >
> > > >
> > > > > --
> > > > > Nicolas Filotto
> > > > > JCR Product Manager
> > > > > Project Manager
> > > > > eXo Platform SAS
> > > > > nicolas.filotto at exoplatform.com
> > > > > +33 (0)6 31 32 92 19
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > Nicolas Filotto
> > > > JCR Product Manager
> > > > Project Manager
> > > > eXo Platform SAS
> > > > nicolas.filotto at exoplatform.com
> > > > +33 (0)6 31 32 92 19
> > >
> > >
> > >
> > >
> > >
> > > --
> > > Nicolas Filotto
> > > JCR Product Manager
> > > Project Manager
> > > eXo Platform SAS
> > > nicolas.filotto at exoplatform.com
> > > +33 (0)6 31 32 92 19
> >
> > Michal
> >
> > _______________________________________________
> > gatein-dev mailing list
> > gatein-dev at lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/gatein-dev
>
>
>
>
>
>
> --
> Nicolas Filotto
> JCR Product Manager
> Project Manager
> eXo Platform SAS
> nicolas.filotto at exoplatform.com
> +33 (0)6 31 32 92 19
>
-------------- next part --------------
trs OracleResultSetImpl (id=494)
autoRefetch true
close_statement_on_close true
closed false
connection T4CConnection (id=496)
accumulateBatchResult true
all8 T4C8Oall (id=516)
auth T4CTTIoauthenticate (id=519)
autoCommitSet true
bfileMsg T4C8TTIBfile (id=522)
bigEndian null
blobMsg T4C8TTIBlob (id=524)
byteOutput (id=526)
charOutput (id=529)
clearStatementMetaData false
clientData null
clientId null
clientIdSet false
clobMsg T4C8TTIClob (id=531)
close8 T4C8Oclose (id=533)
closeCallback null
commoncall T4C7Ocommoncall (id=535)
connection null
connectionProperties Properties (id=741)
conversion DBConversion (id=746)
convertNcharLiterals false
createDescriptorUseCurrentSchemaForSchemaName false
cursorToClose (id=748)
cursorToCloseOffset 0
database "vmg05.mw.lab.eng.bos.redhat.com:1521:qaora10" (id=779)
databaseMetaData OracleDatabaseMetaData (id=780)
databaseProductVersion "" (id=784)
dbTzCalendar null
defaultAutoRefetch true
defaultBatch 1
defaultFixedString false
defaultNChar false
defaultRowPrefetch 10
describe T4C8Odscrarr (id=786)
descriptorCache Hashtable<K,V> (id=788)
disableDefineColumnType false
driverExtension T4CDriverExtension (id=789)
dty T4C8TTIdty (id=792)
EMPTY_BYTE (id=795)
endToEndAnyChanged false
endToEndECIDSequenceNumber 5
endToEndHasChanged (id=797)
endToEndValues null
fdo null
includeSynonyms false
isLoggedOn true
isMemoryFreedOnEnteringCache false
isProxy false
j2ee13Compliant false
javaObjectMap Hashtable<K,V> (id=799)
k2rpc T4CTTIk2rpc (id=800)
lifecycle 1
logicalConnectionAttached null
LOGON_MODE 0
looseTimestampDateCheck false
map null
mare T4CMAREngine (id=802)
maxRawBytesPlsql 32512
maxRawBytesSql 2000
maxVcsBytesPlsql 32512
maxVcsCharsSql 32766
maxVcsNCharsSql 32766
minVcsBindSize 0
namedTypeAccessorByteLen 0
namespaces Hashtable<K,V> (id=1194)
net NSProtocol (id=1195)
oer T4CTTIoer (id=1199)
okeyval T4CTTIokeyval (id=1201)
oscid T4CTTIoscid (id=1203)
oses T4CTTIoses (id=1205)
otxen T4CTTIOtxen (id=1207)
otxse T4CTTIOtxse (id=1209)
password "epp5uidb" (id=1211)
plsqlCompilerWarnings false
privateData null
pro T4C8TTIpro (id=1212)
processEscapes true
protocol "thin" (id=1214)
protocolId 0
queryToClose (id=1215)
queryToCloseOffset 0
readAsNonStream false
readOnly false
refTypeAccessorByteLen 0
reportRemarks false
ressourceManagerId "0000" (id=1216)
restrictGetTables false
retainV9BehaviorForLong false
rxd null
savedUser null
savepointStatement null
serialNumber 55733
sessionId 509
sessionProperties null
sessionTimeZone null
setCHARCharSetObj CharacterSet1Byte (id=1219)
setCHARNCharSetObj CharacterSetAL16UTF16 (id=1223)
shortOutput (id=1226)
spawnNewThreadToCancel false
sqlObj null
sqlWarning null
statementCache null
statementHoldingLine null
statements T4CPreparedStatement (id=498)
sto T4CTTIsto (id=1229)
streamChunkSize 255
timeout null
txnLevel 2
txnMode 0
url "jdbc:oracle:thin:@vmg05.mw.lab.eng.bos.redhat.com:1521:qaora10" (id=1231)
useDMSForEndToEnd false
useFetchSizeWithLongColumn false
user "EPP5UIDB" (id=1232)
usingXA false
v8Compatible false
ver T4C7Oversion (id=1234)
versionNumber 10204
wellBehavedStatementReuse false
wrapper null
xaWantsError false
explicitly_closed false
m_emptyRset false
sqlWarning null
statement T4CPreparedStatement (id=498)
accessorByteOffset 0
accessorCharOffset 0
accessors Accessor[5] (id=499)
accessorShortOffset 0
autoKeyInfo null
autoRefetch true
autoRollback 2
batch 1
bindBufferCapacity 1
bindByteOffset 0
bindBytes null
bindByteSubRange 0
bindCharOffset 0
bindChars (id=503)
bindCharSubRange 0
binders Binder[1][] (id=504)
bindIndicatorOffset 0
bindIndicators (id=508)
bindIndicatorSubRange 0
c_state 0
cachedBindByteSize 0
cachedBindCharSize 0
cachedBindIndicatorSize 0
cachedDefineByteSize 0
cachedDefineCharSize 0
cachedDefineIndicatorSize 0
cacheState 1
charMaxCharsSql 0
charMaxNCharsSql 0
checkBindTypes true
children null
clearParameters false
closed false
columnsDefinedByUser false
columnSetNull false
connection T4CConnection (id=496)
convertNcharLiterals false
creationState 0
currentBatchBindAccessors null
currentBatchCharLens (id=547)
currentBatchFormOfUse (id=550)
currentBatchNeedToPrepareBinds false
currentRank 0
currentResultSet OracleResultSetImpl (id=494)
currentRow -1
currentRowBindAccessors null
currentRowBinders Binder[2] (id=551)
currentRowCharLens (id=552)
currentRowFormOfUse (id=553)
currentRowNeedToPrepareBinds false
cursorId 2
defaultCalendar null
defaultFetchDirection 1000
defaultRowPrefetch 10
defaultTZ null
defineBytes (id=555)
defineByteSubRange 0
defineChars (id=557)
defineCharSubRange 80840
definedColumnFormOfUse null
definedColumnSize null
definedColumnType null
defineIndicators (id=558)
defineIndicatorSubRange 50
defineLengthSubRange 0
definesBatchSize 10
described true
describedWithNames true
digits (id=559)
executionType 1
firstRowInBatch 0
fixedString false
gotLastBatch true
hasIbtBind false
ibtBindByteOffset 0
ibtBindBytes null
ibtBindCharOffset 0
ibtBindChars null
ibtBindIndicatorOffset 0
ibtBindIndicators null
ibtBindIndicatorSize 0
indexOfPostPonedColumn (id=561)
indicatorsOffset 25
isAutoGeneratedKey false
isExecuting false
isOpen true
isServerCharSetFixedWidth false
isServerNCharSetFixedWidth true
lastBinders Binder[2] (id=563)
lastBoundByteLens (id=564)
lastBoundByteOffset 0
lastBoundByteOffsets (id=565)
lastBoundBytes null
lastBoundCharLens (id=566)
lastBoundCharOffset 0
lastBoundCharOffsets (id=567)
lastBoundChars (id=503)
lastBoundInds (id=568)
lastBoundLens (id=569)
lastBoundNeeded false
lastBoundTypeBytes (id=570)
lastBoundTypeOtypes OracleTypeADT[2] (id=571)
lastIndex 0
m_batchItems Vector<E> (id=574)
m_batchStyle 0
maxCharSize 1
maxFieldSize 0
maxNCharSize 2
maxRawBytesPlsql 32512
maxRawBytesSql 2000
maxRows 0
maxStreamCharsSql 2147483647
maxStreamNCharsSql 1000
maxVcsBytesPlsql 32512
maxVcsCharsPlsql 32512
maxVcsCharsSql 32766
maxVcsNCharsPlsql 16256
maxVcsNCharsSql 32766
minVcsBindSize 0
nbPostPonedColumns (id=583)
needToAddIdentifier false
needToParse false
needToPrepareDefineBuffer false
needToSendOalToFetch false
next null
nextChild null
nextStream null
noMoreUpdateCounts false
numberOfBindPositions 2
numberOfBindRowsAllocated 1
numberOfBoundRows 1
numberOfDefinePositions 5
numReturnParams 0
oacdefSent T4CTTIoac[2] (id=586)
oldTempBlobsToFree null
oldTempClobsToFree null
outBindAccessors null
parameterBigDecimal null
parameterDate null
parameterDatum null
parameterDouble null
parameterFloat null
parameterInt null
parameterLong null
parameterOtype null
parameterPlsqlIbt null
parameterStream null
parameterString String[1][] (id=589)
parameterTime null
parameterTimestamp null
prematureBatchCount 0
preparedAllBinds true
preparedCharBinds true
prev null
processEscapes true
pushedBatches null
pushedBatchesTail null
queryTimeout 0
realRsetType 1
returnParamAccessors null
returnParamBytes null
returnParamChars null
returnParamIndicators null
returnParamMeta null
returnParamRowBytes 0
returnParamRowChars 0
returnParamsFetched false
returnResultSet null
rowPrefetch 10
rowPrefetchChanged false
rowPrefetchInLastFetch 10
rowsDmlReturned 0
rowsProcessed 0
rsetCache null
scrollRset null
scrollRsetTypeSolved false
serverCursor false
SetBigStringTryClob 0
sizeTmpByteArray 4000
sqlKind 0
sqlObject OracleSql (id=595)
sqlStringChanged true
sqlWarning null
statementType 1
streamList null
t4Connection T4CConnection (id=496)
tempBlobsToFree null
tempClobsToFree null
theBfileBinder BfileBinder (id=598)
theBfileNullBinder BfileNullBinder (id=601)
theBigDecimalBinder BigDecimalBinder (id=603)
theBINARY_DOUBLEBinder BINARY_DOUBLEBinder (id=605)
theBINARY_DOUBLENullBinder BINARY_DOUBLENullBinder (id=608)
theBINARY_FLOATBinder BINARY_FLOATBinder (id=610)
theBINARY_FLOATNullBinder BINARY_FLOATNullBinder (id=612)
theBinaryDoubleBinder BinaryDoubleBinder (id=614)
theBinaryDoubleNullBinder BinaryDoubleNullBinder (id=616)
theBinaryFloatBinder BinaryFloatBinder (id=618)
theBinaryFloatNullBinder BinaryFloatNullBinder (id=621)
theBlobBinder BlobBinder (id=623)
theBlobNullBinder BlobNullBinder (id=625)
theBooleanBinder BooleanBinder (id=627)
theByteBinder ByteBinder (id=629)
theClobBinder ClobBinder (id=631)
theClobNullBinder ClobNullBinder (id=633)
theDateBinder DateBinder (id=635)
theDateNullBinder DateNullBinder (id=637)
theDoubleBinder null
theFixedCHARBinder FixedCHARBinder (id=640)
theFixedCHARNullBinder FixedCHARNullBinder (id=642)
theFloatBinder null
theIntBinder IntBinder (id=644)
theIntervalDSBinder IntervalDSBinder (id=648)
theIntervalDSNullBinder IntervalDSNullBinder (id=652)
theIntervalYMBinder IntervalYMBinder (id=655)
theIntervalYMNullBinder IntervalYMNullBinder (id=658)
theLongBinder LongBinder (id=660)
theLongRawStreamBinder LongRawStreamBinder (id=662)
theLongStreamBinder LongStreamBinder (id=664)
theNamedTypeBinder NamedTypeBinder (id=666)
theNamedTypeNullBinder NamedTypeNullBinder (id=668)
theOracleDateBinder OracleDateBinder (id=645)
theOracleNumberBinder OracleNumberBinder (id=649)
theOracleTimestampBinder OracleTimestampBinder (id=654)
theOutBinder OutBinder (id=672)
thePlsqlIbtBinder PlsqlIbtBinder (id=674)
thePlsqlNullBinder PlsqlIbtNullBinder (id=676)
thePlsqlRawBinder PlsqlRawBinder (id=679)
theRawBinder RawBinder (id=681)
theRawNullBinder RawNullBinder (id=683)
theRefTypeBinder RefTypeBinder (id=685)
theRefTypeNullBinder RefTypeNullBinder (id=687)
theReturnParamBinder ReturnParamBinder (id=689)
theRowidBinder T4CRowidBinder (id=692)
theRowidNullBinder T4CRowidNullBinder (id=695)
theSetCHARBinder SetCHARBinder (id=697)
theSetCHARNullBinder SetCHARNullBinder (id=699)
theShortBinder ShortBinder (id=701)
theStringBinder StringBinder (id=703)
theTimeBinder TimeBinder (id=706)
theTimestampBinder TimestampBinder (id=708)
theTimestampNullBinder TimestampNullBinder (id=710)
theTSLTZBinder TSLTZBinder (id=712)
theTSLTZNullBinder TSLTZNullBinder (id=714)
theTSTZBinder TSTZBinder (id=716)
theTSTZNullBinder TSTZNullBinder (id=718)
theVarcharNullBinder VarcharNullBinder (id=720)
theVarnumNullBinder VarnumNullBinder (id=722)
tmpBindsByteArray (id=724)
tmpByteArray (id=725)
totalBindByteLength 0
totalBindCharLength 13
totalBindIndicatorLength 29
totalRowsVisited 0
userRsetType 1
validRows 1
valueLengthsOffset 27
More information about the gatein-dev
mailing list