You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@trafodion.apache.org by Pierre Smits <pi...@gmail.com> on 2015/06/17 08:40:02 UTC
Manual installation of Trafodion
Hi All,
I am trying to execute a PoC whereby applying Trafodion as the persistence
layer for an Apache OFBiz setup. Unfortunately, I have to execute this PoC
on a Mac. I have looked at both the CDH and the HDP to see if there were
installers available for Apple, but both provided no easy means to install
those... So everything needs to be installed manually.
As I was browsing through the pages of trafodion.org I only found pages
related to applying the installer to implement Trafodion on top of either
HDP or HDP. So I am looking for some guidance (pointers, tips and tricks).
Thus far I have Hadoop (r2.7.0), HBase (r1.0.1) and Hive (r1.1.1) up and
running on the Mac. What else do I need to look at?
Best regards,
Pierre Smits
*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com
Re: Manual installation of Trafodion
Posted by Pierre Smits <pi...@gmail.com>.
Hi Suresh,
My apologies for the long delay. I have been quite busy with other stuff,
which required me to put it on the back burner and prevented me to react
sooner.
No, I haven't had it working yet. I need to figure out a way to get the
trafCi client working on the host and see if I can connect from there to
Trafodion in the guest. When I have that sorted out, I can look at the
connection settings in OFBiz and see if I can get it connected by applying
various configuration changes.
Best regards,
Pierre Smits
*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com
On Sun, Jun 28, 2015 at 6:21 AM, Subbiah, Suresh <Su...@hp.com>
wrote:
> Hi Pierre,
>
> Were you able to connect to Trafodion sandbox from OFBiz ?
>
> Thanks
> Suresh
>
>
> -----Original Message-----
> From: Brown, Matt (Trafodion)
> Sent: Sunday, June 21, 2015 8:31 AM
> To: dev@trafodion.incubator.apache.org
> Subject: RE: Manual installation of Trafodion
>
> Hi Pierre,
>
> The DcsMaster, listening on default port 37800, can only service JDBC Type
> 4 clients, not telnet, so the behavior you're seeing is expected.
>
> Re the conf/dcs-site.xml file, Trafodion/DCS component design follows
> HBase configuration model in that there's a dcs-default.xml file. Any site
> specific configuration property may be overridden by adding it in the
> dcs-site.xml. This is explained in The DCS Reference Guide, Chapter 7
> "Configuration Files" which can be found in the "docs" directory. Point a
> browser at index.html to peruse the manual. All of the properties in
> dcs-default.xml are detailed in that chapter. And, like HBase, the
> information in chapter 7.1 is generated automatically from the contents of
> the dcs-default.xml file so, since it's part of the DCS build, it's always
> in sync with contributor changes. We also need to consider that the
> Trafodion installer writes to the dcs-site.xml file based on user inputs
> during the install process.
>
> Hope that helps
>
> Regards,
>
> Matt
>
> -----Original Message-----
> From: Pierre Smits [mailto:pierre.smits@gmail.com]
> Sent: Sunday, June 21, 2015 2:43 AM
> To: dev@trafodion.incubator.apache.org
> Subject: Re: Manual installation of Trafodion
>
> Hi Suresh, All,
>
> After a restart with sqstart sqps showed that mxosrvr has 2 references.
> And trafci was able to connect.
>
> In dcs*/conf/dcs-site.xml no dcs.master.info.port configuration property
> is available. But firing the browser to point to port 40010 worked, showing
> that the DcsMaster has:
> Listener37800:100
> sandbox.local <http://sandbox.local:40031> 1 Sun Jun 21 02:00:05 PDT 2015
> YES CONNECTED 0 22787 $Z000IL2 10.0.1.38 37803 sandbox TrafCI 10.0.1.38
> 55550 Sun Jun 21 02:00:05 PDT 2015 YES AVAILABLE 0 22626 $Z000IGG
> 10.0.1.38
> 37802
>
> When JIRA is available, I will create an improvement issue to include the
> dcs.master.info.port in dcs-site.xml (it is better to have it in for and
> improved user experience), and will provide a patch subsequently.
>
> So I tried to telnet into port 37800 from my host to the sandbox vm, and
> it succeeded. However, logs showed no indication of any connection from
> host to guest vm.
>
> Best regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
> On Sun, Jun 21, 2015 at 3:33 AM, Subbiah, Suresh <Su...@hp.com>
> wrote:
>
> > Hi Pierre,
> >
> > Thanks for checking.
> >
> > Let's try a few more things.
> >
> > 1) does "sqps" show mxosrvr processes
> > 2) If yes, can you please type "trafci" from the shell. Trafci is a
> > JDBC
> > T4 client that ships with Trafodion. It will be interesting to see if
> > this can connect.
> > 3) I am not sure what the default value for dcs.master.info.port is.
> > If you can find it from dcs*/conf/dcs-site.xml, then we can use the
> > web interface to see the status of the connection. From within the
> > sandbox , use a browser to point to the address
> localhost:<dcs.master.info.port> .
> > This port number will be close to 37800 port used to make a jdbc
> connection.
> > 4) If none of this works, we can also try the logs described in
> > http://docs.trafodion.org/dcs_docs/index.html#troubleshooting
> >
> > Thank you
> > Suresh
> >
> >
> >
> >
> > -----Original Message-----
> > From: Pierre Smits [mailto:pierre.smits@gmail.com]
> > Sent: Saturday, June 20, 2015 7:18 PM
> > To: dev@trafodion.incubator.apache.org
> > Subject: Re: Manual installation of Trafodion
> >
> > Hi Suresh,
> >
> > Yes, all Trafodion processes were started. Had the check done before I
> > started OFBiz to load some seed data (which starts with creating the
> > tables). And sqlci gave me the notification that Trafodion was already
> > initialized.
> >
> > Thank you for your time.
> >
> > Best regards,
> >
> > Pierre Smits
> >
> > *ORRTIZ.COM <http://www.orrtiz.com>*
> > Services & Solutions for Cloud-
> > Based Manufacturing, Professional
> > Services and Retail & Trade
> > http://www.orrtiz.com
> >
> > On Sun, Jun 21, 2015 at 2:08 AM, Subbiah, Suresh
> > <Su...@hp.com>
> > wrote:
> >
> > > Hi Pierre,
> > >
> > > One approach here is to determine if Trafodion is started and
> > > functioning correctly on the sandbox before we connect to it.
> > > Could you please get on the sandbox and type "sqcheck". It should
> > > show all the Trafodion processes that are up.
> > >
> > > If the output looks OK, you could start a "sqlci" session (an
> > > interactive SQL session with Trafodion, on cluster, without
> > > connectivity) And try a few commands. I think metadata tables will
> > > need to be created with "initialize trafodion" if this has not been
> > > done
> > already.
> > >
> > > None of this maybe related to the connection problem, but it could
> > > help isolate the issue.
> > >
> > > Thanks
> > > Suresh
> > >
> > >
> > > -----Original Message-----
> > > From: Pierre Smits [mailto:pierre.smits@gmail.com]
> > > Sent: Saturday, June 20, 2015 7:00 PM
> > > To: dev@trafodion.incubator.apache.org
> > > Subject: Re: Manual installation of Trafodion
> > >
> > > Hi Suresh,
> > >
> > > Thanks for the quick response.
> > >
> > > So I defined the connection as follows (for the connection to the
> > > ofbiz namespace as follows:
> > >
> > > <datasource name="trafodion"
> > > > add-missing-on-start="true"
> > > > alias-view-columns="false"
> > > > check-on-start="true"
> > > > field-type-name="trafodion"
> > > > helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> > > > join-style="ansi"
> > > > result-fetch-size="50"
> > > > schema-name="ofbiz"
> > > > use-binary-type-for-blob="true"
> > > > use-fk-initially-deferred="false"
> > > > use-order-by-nulls="true"
> > > > >
> > > > <read-data reader-name="seed"/>
> > > > <read-data reader-name="seed-initial"/>
> > > > <read-data reader-name="ext"/>
> > > > <read-data reader-name="demo"/>
> > > > <inline-jdbc
> > > > jdbc-driver="org.trafodion.jdbc.t4.T4Driver"
> > > > jdbc-uri="jdbc:t4jdbc://10.0.1.38:37800/ofbiz"
> > > > jdbc-username="ofbiz"
> > > > jdbc-password="ofbiz"
> > > > isolation-level="ReadCommitted"
> > > > pool-minsize="2"
> > > > pool-maxsize="250"
> > > > time-between-eviction-runs-millis="600000"/>
> > > > </datasource>
> > >
> > >
> > > Which is the common way to define the connection in OFBiz, and fired
> up.
> > > And I got following errors (my apologies for the lengthiness):
> > >
> > > 2015-06-21 01:50:37,318 |OFBiz-batch-3 |GenericDelegator
> > > |I| Delegator "default" initializing helper "trafodion" for entity
> > > group "org.ofbiz".
> > > 2015-06-21 01:50:37,318 |OFBiz-batch-1 |GenericDelegator
> > > |I| Delegator "default" initializing helper "trafodiontenant" for
> > > entity group "org.ofbiz.tenant".
> > > 2015-06-21 01:50:37,318 |OFBiz-batch-2 |GenericDelegator
> > > |I| Delegator "default" initializing helper "trafodionolap" for
> > > entity group "org.ofbiz.olap".
> > > 2015-06-21 01:50:37,324 |OFBiz-batch-3 |GenericDelegator
> > > |I| Doing database check as requested in entityengine.xml with
> > > addMissing=true
> > > 2015-06-21 01:50:37,324 |OFBiz-batch-1 |GenericDelegator
> > > |I| Doing database check as requested in entityengine.xml with
> > > addMissing=true
> > > 2015-06-21 01:50:37,324 |OFBiz-batch-2 |GenericDelegator
> > > |I| Doing database check as requested in entityengine.xml with
> > > addMissing=true
> > > 2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
> > > |E| Unable to establish a connection with the database for
> > > helperName [trafodion]... Error was: java.sql.SQLException: Unable
> > > to acquire a new connection from the pool
> > > 2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
> > > |E| Unable to establish a connection with the database, no
> > > additional information available.
> > > 2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
> > > |E| Could not get table name information from the database, aborting.
> > > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > > |I| Database Product Name is Trafodion
> > > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > > |I| Database Product Version is 1.1
> > > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > > |I| Database Driver Name is org.trafodion.jdbc.t4.T4Driver
> > > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > > |I| Database Driver Version is Traf_JDBC_Type4_Build_17dd8d9
> > > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > > |I| Database Driver JDBC Version is 3.1
> > > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > > |I| Database Setting/Support Information (those with a * should be
> > true):
> > > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - supports transactions [true]*
> > > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - isolation None [true]
> > > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - isolation ReadCommitted [true]
> > > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - isolation ReadUncommitted [true]
> > > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - isolation RepeatableRead [true]
> > > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - isolation Serializable [true]
> > > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - forward only type [true]
> > > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - scroll sensitive type [false]
> > > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - scroll insensitive type [true]
> > > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - is case sensitive [false]
> > > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - stores LowerCase [false]
> > > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - stores MixedCase [false]
> > > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - stores UpperCase [true]
> > > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - max table name length [128]
> > > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - max column name length [128]
> > > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - concurrent connections [0]
> > > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - concurrent statements [0]
> > > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - ANSI SQL92 Entry [true]
> > > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - ANSI SQL92 Intermediate [false]
> > > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - ANSI SQL92 Full [false]
> > > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - ODBC SQL Grammar Core [true]
> > > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - ODBC SQL Grammar Extended [false]
> > > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - ODBC SQL Grammar Minimum [true]
> > > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - outer joins [true]*
> > > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - limited outer joins [true]
> > > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - full outer joins [false]
> > > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - group by [true]*
> > > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - group by not in select [false]
> > > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - column aliasing [true]
> > > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - order by not in select [true]
> > > 2015-06-21 01:50:42,811 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - alter table add column [false]*
> > > 2015-06-21 01:50:42,811 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - non-nullable column [true]*
> > > 2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - default fetchsize [100]
> > > 2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
> > > |I| - named parameters [ SKIPPED ]
> > > 2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
> > > |I| Getting Table Info From Database
> > > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > > |I| Database Product Name is Trafodion
> > > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > > |I| Database Product Version is 1.1
> > > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > > |I| Database Driver Name is org.trafodion.jdbc.t4.T4Driver
> > > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > > |I| Database Driver Version is Traf_JDBC_Type4_Build_17dd8d9
> > > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > > |I| Database Driver JDBC Version is 3.1
> > > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > > |I| Database Setting/Support Information (those with a * should be
> > true):
> > > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - supports transactions [true]*
> > > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - isolation None [true]
> > > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - isolation ReadCommitted [true]
> > > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - isolation ReadUncommitted [true]
> > > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - isolation RepeatableRead [true]
> > > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - isolation Serializable [true]
> > > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - forward only type [true]
> > > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - scroll sensitive type [false]
> > > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - scroll insensitive type [true]
> > > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - is case sensitive [false]
> > > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - stores LowerCase [false]
> > > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - stores MixedCase [false]
> > > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - stores UpperCase [true]
> > > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - max table name length [128]
> > > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - max column name length [128]
> > > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - concurrent connections [0]
> > > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - concurrent statements [0]
> > > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - ANSI SQL92 Entry [true]
> > > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - ANSI SQL92 Intermediate [false]
> > > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - ANSI SQL92 Full [false]
> > > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - ODBC SQL Grammar Core [true]
> > > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - ODBC SQL Grammar Extended [false]
> > > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - ODBC SQL Grammar Minimum [true]
> > > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - outer joins [true]*
> > > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - limited outer joins [true]
> > > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - full outer joins [false]
> > > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - group by [true]*
> > > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - group by not in select [false]
> > > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - column aliasing [true]
> > > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - order by not in select [true]
> > > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - alter table add column [false]*
> > > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - non-nullable column [true]*
> > > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - default fetchsize [100]
> > > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > > |I| - named parameters [ SKIPPED ]
> > > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > > |I| Getting Table Info From Database
> > > 2015-06-21 01:50:44,692 |OFBiz-batch-2 |DatabaseUtil
> > > |W| Entity [CurrencyDimension] has no table in the database
> > > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > > |W| Entity [DateDimension] has no table in the database
> > > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > > |W| Entity [InventoryItemFact] has no table in the database
> > > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > > |W| Entity [ProductDimension] has no table in the database
> > > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > > |W| Entity [SalesInvoiceItemFact] has no table in the database
> > > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > > |W| Entity [SalesOrderItemFact] has no table in the database
> > > 2015-06-21 01:50:44,722 |pool-2-thread-1 |DatabaseUtil
> > > |E| Unable to establish a connection with the database for
> > > helperName [trafodionolap]... Error was: java.sql.SQLException:
> > > Unable to acquire a new connection from the pool
> > > java.sql.SQLException: Unable to acquire a new connection from the
> > > pool at
> > >
> > > org.apache.commons.dbcp2.managed.ManagedConnection.updateTransaction
> > > St
> > > atus(ManagedConnection.java:130)
> > > ~[commons-dbcp2-2.1.jar:2.1]
> > > at
> > >
> > > org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedCon
> > > ne
> > > ction.java:60)
> > > ~[commons-dbcp2-2.1.jar:2.1]
> > > at
> > >
> > > org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(Man
> > > ag
> > > edDataSource.java:82)
> > > ~[commons-dbcp2-2.1.jar:2.1]
> > > at
> > >
> > > org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCP
> > > Co
> > > nnectionFactory.java:63)
> > > ~[ofbiz-entity.jar:?]
> > > at
> > >
> > > org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(Geronimo
> > > Tr
> > > ansactionFactory.java:83)
> > > ~[ofbiz-geronimo.jar:?]
> > > at
> > > org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:9
> > > 6)
> > > ~[ofbiz-entity.jar:?]
> > > at
> > > org.ofbiz.entity.jdbc.DatabaseUtil.createTable(DatabaseUtil.java:159
> > > 1)
> > > [ofbiz-entity.jar:?]
> > > at
> > >
> > > org.ofbiz.entity.jdbc.DatabaseUtil$CreateTableCallable.call(Database
> > > Ut
> > > il.java:1529)
> > > [ofbiz-entity.jar:?]
> > > at
> > >
> > > org.ofbiz.entity.jdbc.DatabaseUtil$CreateTableCallable.call(Database
> > > Ut
> > > il.java:1515)
> > > [ofbiz-entity.jar:?]
> > > at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> > > [?:1.8.0_45] at
> > >
> > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor
> > > .j
> > > ava:1142)
> > > [?:1.8.0_45]
> > > at
> > >
> > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.
> > > java:617)
> > > [?:1.8.0_45]
> > > at java.lang.Thread.run(Thread.java:745) [?:1.8.0_45] Caused by:
> > > org.trafodion.jdbc.t4.HPT4Exception: The message id:
> > > as_connect_message_error With parameters: server handle not
> > > available at
> > >
> > > org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.j
> > > av
> > > a:304)
> > > ~[jdbcT4.jar:?]
> > > at
> > >
> > > org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.j
> > > av
> > > a:238)
> > > ~[jdbcT4.jar:?]
> > > at
> > >
> > > org.trafodion.jdbc.t4.InterfaceConnection.connect(InterfaceConnection.
> > > java:876)
> > > ~[jdbcT4.jar:?]
> > > at
> > >
> > > org.trafodion.jdbc.t4.InterfaceConnection.<init>(InterfaceConnection
> > > .j
> > > ava:173)
> > > ~[jdbcT4.jar:?]
> > > at
> > >
> > > org.trafodion.jdbc.t4.TrafT4Connection.makeConnection(TrafT4Connecti
> > > on
> > > .java:1608)
> > > ~[jdbcT4.jar:?]
> > > at
> > > org.trafodion.jdbc.t4.TrafT4Connection.<init>(TrafT4Connection.java:
> > > 15
> > > 61)
> > > ~[jdbcT4.jar:?]
> > > at
> > > org.trafodion.jdbc.t4.HPT4DataSource.getConnection(HPT4DataSource.ja
> > > va
> > > :129)
> > > ~[jdbcT4.jar:?]
> > > at
> > > org.trafodion.jdbc.t4.HPT4DataSource.getConnection(HPT4DataSource.ja
> > > va
> > > :173)
> > > ~[jdbcT4.jar:?]
> > > at org.trafodion.jdbc.t4.T4Driver.connect(T4Driver.java:183)
> > > ~[jdbcT4.jar:?]
> > >
> > >
> > > And more...
> > >
> > > Do you perhaps have any ideas on how to resolve this?
> > >
> > > Best regards,
> > >
> > > Pierre Smits
> > >
> > > *ORRTIZ.COM <http://www.orrtiz.com>* Services & Solutions for Cloud-
> > > Based Manufacturing, Professional Services and Retail & Trade
> > > http://www.orrtiz.com
> > >
> >
>
RE: Manual installation of Trafodion
Posted by "Subbiah, Suresh" <Su...@hp.com>.
Hi Pierre,
Were you able to connect to Trafodion sandbox from OFBiz ?
Thanks
Suresh
-----Original Message-----
From: Brown, Matt (Trafodion)
Sent: Sunday, June 21, 2015 8:31 AM
To: dev@trafodion.incubator.apache.org
Subject: RE: Manual installation of Trafodion
Hi Pierre,
The DcsMaster, listening on default port 37800, can only service JDBC Type 4 clients, not telnet, so the behavior you're seeing is expected.
Re the conf/dcs-site.xml file, Trafodion/DCS component design follows HBase configuration model in that there's a dcs-default.xml file. Any site specific configuration property may be overridden by adding it in the dcs-site.xml. This is explained in The DCS Reference Guide, Chapter 7 "Configuration Files" which can be found in the "docs" directory. Point a browser at index.html to peruse the manual. All of the properties in dcs-default.xml are detailed in that chapter. And, like HBase, the information in chapter 7.1 is generated automatically from the contents of the dcs-default.xml file so, since it's part of the DCS build, it's always in sync with contributor changes. We also need to consider that the Trafodion installer writes to the dcs-site.xml file based on user inputs during the install process.
Hope that helps
Regards,
Matt
-----Original Message-----
From: Pierre Smits [mailto:pierre.smits@gmail.com]
Sent: Sunday, June 21, 2015 2:43 AM
To: dev@trafodion.incubator.apache.org
Subject: Re: Manual installation of Trafodion
Hi Suresh, All,
After a restart with sqstart sqps showed that mxosrvr has 2 references.
And trafci was able to connect.
In dcs*/conf/dcs-site.xml no dcs.master.info.port configuration property is available. But firing the browser to point to port 40010 worked, showing that the DcsMaster has:
Listener37800:100
sandbox.local <http://sandbox.local:40031> 1 Sun Jun 21 02:00:05 PDT 2015 YES CONNECTED 0 22787 $Z000IL2 10.0.1.38 37803 sandbox TrafCI 10.0.1.38
55550 Sun Jun 21 02:00:05 PDT 2015 YES AVAILABLE 0 22626 $Z000IGG 10.0.1.38
37802
When JIRA is available, I will create an improvement issue to include the dcs.master.info.port in dcs-site.xml (it is better to have it in for and improved user experience), and will provide a patch subsequently.
So I tried to telnet into port 37800 from my host to the sandbox vm, and it succeeded. However, logs showed no indication of any connection from host to guest vm.
Best regards,
Pierre Smits
*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com
On Sun, Jun 21, 2015 at 3:33 AM, Subbiah, Suresh <Su...@hp.com>
wrote:
> Hi Pierre,
>
> Thanks for checking.
>
> Let's try a few more things.
>
> 1) does "sqps" show mxosrvr processes
> 2) If yes, can you please type "trafci" from the shell. Trafci is a
> JDBC
> T4 client that ships with Trafodion. It will be interesting to see if
> this can connect.
> 3) I am not sure what the default value for dcs.master.info.port is.
> If you can find it from dcs*/conf/dcs-site.xml, then we can use the
> web interface to see the status of the connection. From within the
> sandbox , use a browser to point to the address localhost:<dcs.master.info.port> .
> This port number will be close to 37800 port used to make a jdbc connection.
> 4) If none of this works, we can also try the logs described in
> http://docs.trafodion.org/dcs_docs/index.html#troubleshooting
>
> Thank you
> Suresh
>
>
>
>
> -----Original Message-----
> From: Pierre Smits [mailto:pierre.smits@gmail.com]
> Sent: Saturday, June 20, 2015 7:18 PM
> To: dev@trafodion.incubator.apache.org
> Subject: Re: Manual installation of Trafodion
>
> Hi Suresh,
>
> Yes, all Trafodion processes were started. Had the check done before I
> started OFBiz to load some seed data (which starts with creating the
> tables). And sqlci gave me the notification that Trafodion was already
> initialized.
>
> Thank you for your time.
>
> Best regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
> On Sun, Jun 21, 2015 at 2:08 AM, Subbiah, Suresh
> <Su...@hp.com>
> wrote:
>
> > Hi Pierre,
> >
> > One approach here is to determine if Trafodion is started and
> > functioning correctly on the sandbox before we connect to it.
> > Could you please get on the sandbox and type "sqcheck". It should
> > show all the Trafodion processes that are up.
> >
> > If the output looks OK, you could start a "sqlci" session (an
> > interactive SQL session with Trafodion, on cluster, without
> > connectivity) And try a few commands. I think metadata tables will
> > need to be created with "initialize trafodion" if this has not been
> > done
> already.
> >
> > None of this maybe related to the connection problem, but it could
> > help isolate the issue.
> >
> > Thanks
> > Suresh
> >
> >
> > -----Original Message-----
> > From: Pierre Smits [mailto:pierre.smits@gmail.com]
> > Sent: Saturday, June 20, 2015 7:00 PM
> > To: dev@trafodion.incubator.apache.org
> > Subject: Re: Manual installation of Trafodion
> >
> > Hi Suresh,
> >
> > Thanks for the quick response.
> >
> > So I defined the connection as follows (for the connection to the
> > ofbiz namespace as follows:
> >
> > <datasource name="trafodion"
> > > add-missing-on-start="true"
> > > alias-view-columns="false"
> > > check-on-start="true"
> > > field-type-name="trafodion"
> > > helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> > > join-style="ansi"
> > > result-fetch-size="50"
> > > schema-name="ofbiz"
> > > use-binary-type-for-blob="true"
> > > use-fk-initially-deferred="false"
> > > use-order-by-nulls="true"
> > > >
> > > <read-data reader-name="seed"/>
> > > <read-data reader-name="seed-initial"/>
> > > <read-data reader-name="ext"/>
> > > <read-data reader-name="demo"/>
> > > <inline-jdbc
> > > jdbc-driver="org.trafodion.jdbc.t4.T4Driver"
> > > jdbc-uri="jdbc:t4jdbc://10.0.1.38:37800/ofbiz"
> > > jdbc-username="ofbiz"
> > > jdbc-password="ofbiz"
> > > isolation-level="ReadCommitted"
> > > pool-minsize="2"
> > > pool-maxsize="250"
> > > time-between-eviction-runs-millis="600000"/>
> > > </datasource>
> >
> >
> > Which is the common way to define the connection in OFBiz, and fired up.
> > And I got following errors (my apologies for the lengthiness):
> >
> > 2015-06-21 01:50:37,318 |OFBiz-batch-3 |GenericDelegator
> > |I| Delegator "default" initializing helper "trafodion" for entity
> > group "org.ofbiz".
> > 2015-06-21 01:50:37,318 |OFBiz-batch-1 |GenericDelegator
> > |I| Delegator "default" initializing helper "trafodiontenant" for
> > entity group "org.ofbiz.tenant".
> > 2015-06-21 01:50:37,318 |OFBiz-batch-2 |GenericDelegator
> > |I| Delegator "default" initializing helper "trafodionolap" for
> > entity group "org.ofbiz.olap".
> > 2015-06-21 01:50:37,324 |OFBiz-batch-3 |GenericDelegator
> > |I| Doing database check as requested in entityengine.xml with
> > addMissing=true
> > 2015-06-21 01:50:37,324 |OFBiz-batch-1 |GenericDelegator
> > |I| Doing database check as requested in entityengine.xml with
> > addMissing=true
> > 2015-06-21 01:50:37,324 |OFBiz-batch-2 |GenericDelegator
> > |I| Doing database check as requested in entityengine.xml with
> > addMissing=true
> > 2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
> > |E| Unable to establish a connection with the database for
> > helperName [trafodion]... Error was: java.sql.SQLException: Unable
> > to acquire a new connection from the pool
> > 2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
> > |E| Unable to establish a connection with the database, no
> > additional information available.
> > 2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
> > |E| Could not get table name information from the database, aborting.
> > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > |I| Database Product Name is Trafodion
> > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > |I| Database Product Version is 1.1
> > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > |I| Database Driver Name is org.trafodion.jdbc.t4.T4Driver
> > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > |I| Database Driver Version is Traf_JDBC_Type4_Build_17dd8d9
> > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > |I| Database Driver JDBC Version is 3.1
> > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > |I| Database Setting/Support Information (those with a * should be
> true):
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - supports transactions [true]*
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - isolation None [true]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - isolation ReadCommitted [true]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - isolation ReadUncommitted [true]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - isolation RepeatableRead [true]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - isolation Serializable [true]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - forward only type [true]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - scroll sensitive type [false]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - scroll insensitive type [true]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - is case sensitive [false]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - stores LowerCase [false]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - stores MixedCase [false]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - stores UpperCase [true]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - max table name length [128]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - max column name length [128]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - concurrent connections [0]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - concurrent statements [0]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - ANSI SQL92 Entry [true]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - ANSI SQL92 Intermediate [false]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - ANSI SQL92 Full [false]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - ODBC SQL Grammar Core [true]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - ODBC SQL Grammar Extended [false]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - ODBC SQL Grammar Minimum [true]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - outer joins [true]*
> > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > |I| - limited outer joins [true]
> > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > |I| - full outer joins [false]
> > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > |I| - group by [true]*
> > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > |I| - group by not in select [false]
> > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > |I| - column aliasing [true]
> > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > |I| - order by not in select [true]
> > 2015-06-21 01:50:42,811 |OFBiz-batch-2 |DatabaseUtil
> > |I| - alter table add column [false]*
> > 2015-06-21 01:50:42,811 |OFBiz-batch-2 |DatabaseUtil
> > |I| - non-nullable column [true]*
> > 2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
> > |I| - default fetchsize [100]
> > 2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
> > |I| - named parameters [ SKIPPED ]
> > 2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
> > |I| Getting Table Info From Database
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| Database Product Name is Trafodion
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| Database Product Version is 1.1
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| Database Driver Name is org.trafodion.jdbc.t4.T4Driver
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| Database Driver Version is Traf_JDBC_Type4_Build_17dd8d9
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| Database Driver JDBC Version is 3.1
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| Database Setting/Support Information (those with a * should be
> true):
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| - supports transactions [true]*
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| - isolation None [true]
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| - isolation ReadCommitted [true]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - isolation ReadUncommitted [true]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - isolation RepeatableRead [true]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - isolation Serializable [true]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - forward only type [true]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - scroll sensitive type [false]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - scroll insensitive type [true]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - is case sensitive [false]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - stores LowerCase [false]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - stores MixedCase [false]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - stores UpperCase [true]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - max table name length [128]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - max column name length [128]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - concurrent connections [0]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - concurrent statements [0]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - ANSI SQL92 Entry [true]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - ANSI SQL92 Intermediate [false]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - ANSI SQL92 Full [false]
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - ODBC SQL Grammar Core [true]
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - ODBC SQL Grammar Extended [false]
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - ODBC SQL Grammar Minimum [true]
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - outer joins [true]*
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - limited outer joins [true]
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - full outer joins [false]
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - group by [true]*
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - group by not in select [false]
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| - column aliasing [true]
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| - order by not in select [true]
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| - alter table add column [false]*
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| - non-nullable column [true]*
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| - default fetchsize [100]
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| - named parameters [ SKIPPED ]
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| Getting Table Info From Database
> > 2015-06-21 01:50:44,692 |OFBiz-batch-2 |DatabaseUtil
> > |W| Entity [CurrencyDimension] has no table in the database
> > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > |W| Entity [DateDimension] has no table in the database
> > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > |W| Entity [InventoryItemFact] has no table in the database
> > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > |W| Entity [ProductDimension] has no table in the database
> > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > |W| Entity [SalesInvoiceItemFact] has no table in the database
> > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > |W| Entity [SalesOrderItemFact] has no table in the database
> > 2015-06-21 01:50:44,722 |pool-2-thread-1 |DatabaseUtil
> > |E| Unable to establish a connection with the database for
> > helperName [trafodionolap]... Error was: java.sql.SQLException:
> > Unable to acquire a new connection from the pool
> > java.sql.SQLException: Unable to acquire a new connection from the
> > pool at
> >
> > org.apache.commons.dbcp2.managed.ManagedConnection.updateTransaction
> > St
> > atus(ManagedConnection.java:130)
> > ~[commons-dbcp2-2.1.jar:2.1]
> > at
> >
> > org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedCon
> > ne
> > ction.java:60)
> > ~[commons-dbcp2-2.1.jar:2.1]
> > at
> >
> > org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(Man
> > ag
> > edDataSource.java:82)
> > ~[commons-dbcp2-2.1.jar:2.1]
> > at
> >
> > org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCP
> > Co
> > nnectionFactory.java:63)
> > ~[ofbiz-entity.jar:?]
> > at
> >
> > org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(Geronimo
> > Tr
> > ansactionFactory.java:83)
> > ~[ofbiz-geronimo.jar:?]
> > at
> > org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:9
> > 6)
> > ~[ofbiz-entity.jar:?]
> > at
> > org.ofbiz.entity.jdbc.DatabaseUtil.createTable(DatabaseUtil.java:159
> > 1)
> > [ofbiz-entity.jar:?]
> > at
> >
> > org.ofbiz.entity.jdbc.DatabaseUtil$CreateTableCallable.call(Database
> > Ut
> > il.java:1529)
> > [ofbiz-entity.jar:?]
> > at
> >
> > org.ofbiz.entity.jdbc.DatabaseUtil$CreateTableCallable.call(Database
> > Ut
> > il.java:1515)
> > [ofbiz-entity.jar:?]
> > at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> > [?:1.8.0_45] at
> >
> > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor
> > .j
> > ava:1142)
> > [?:1.8.0_45]
> > at
> >
> > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.
> > java:617)
> > [?:1.8.0_45]
> > at java.lang.Thread.run(Thread.java:745) [?:1.8.0_45] Caused by:
> > org.trafodion.jdbc.t4.HPT4Exception: The message id:
> > as_connect_message_error With parameters: server handle not
> > available at
> >
> > org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.j
> > av
> > a:304)
> > ~[jdbcT4.jar:?]
> > at
> >
> > org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.j
> > av
> > a:238)
> > ~[jdbcT4.jar:?]
> > at
> >
> > org.trafodion.jdbc.t4.InterfaceConnection.connect(InterfaceConnection.
> > java:876)
> > ~[jdbcT4.jar:?]
> > at
> >
> > org.trafodion.jdbc.t4.InterfaceConnection.<init>(InterfaceConnection
> > .j
> > ava:173)
> > ~[jdbcT4.jar:?]
> > at
> >
> > org.trafodion.jdbc.t4.TrafT4Connection.makeConnection(TrafT4Connecti
> > on
> > .java:1608)
> > ~[jdbcT4.jar:?]
> > at
> > org.trafodion.jdbc.t4.TrafT4Connection.<init>(TrafT4Connection.java:
> > 15
> > 61)
> > ~[jdbcT4.jar:?]
> > at
> > org.trafodion.jdbc.t4.HPT4DataSource.getConnection(HPT4DataSource.ja
> > va
> > :129)
> > ~[jdbcT4.jar:?]
> > at
> > org.trafodion.jdbc.t4.HPT4DataSource.getConnection(HPT4DataSource.ja
> > va
> > :173)
> > ~[jdbcT4.jar:?]
> > at org.trafodion.jdbc.t4.T4Driver.connect(T4Driver.java:183)
> > ~[jdbcT4.jar:?]
> >
> >
> > And more...
> >
> > Do you perhaps have any ideas on how to resolve this?
> >
> > Best regards,
> >
> > Pierre Smits
> >
> > *ORRTIZ.COM <http://www.orrtiz.com>* Services & Solutions for Cloud-
> > Based Manufacturing, Professional Services and Retail & Trade
> > http://www.orrtiz.com
> >
>
RE: Manual installation of Trafodion
Posted by "Brown, Matt (Trafodion)" <ma...@hp.com>.
Hi Pierre,
The DcsMaster, listening on default port 37800, can only service JDBC Type 4 clients, not telnet, so the behavior you're seeing is expected.
Re the conf/dcs-site.xml file, Trafodion/DCS component design follows HBase configuration model in that there's a dcs-default.xml file. Any site specific configuration property may be overridden by adding it in the dcs-site.xml. This is explained in The DCS Reference Guide, Chapter 7 "Configuration Files" which can be found in the "docs" directory. Point a browser at index.html to peruse the manual. All of the properties in dcs-default.xml are detailed in that chapter. And, like HBase, the information in chapter 7.1 is generated automatically from the contents of the dcs-default.xml file so, since it's part of the DCS build, it's always in sync with contributor changes. We also need to consider that the Trafodion installer writes to the dcs-site.xml file based on user inputs during the install process.
Hope that helps
Regards,
Matt
-----Original Message-----
From: Pierre Smits [mailto:pierre.smits@gmail.com]
Sent: Sunday, June 21, 2015 2:43 AM
To: dev@trafodion.incubator.apache.org
Subject: Re: Manual installation of Trafodion
Hi Suresh, All,
After a restart with sqstart sqps showed that mxosrvr has 2 references.
And trafci was able to connect.
In dcs*/conf/dcs-site.xml no dcs.master.info.port configuration property is available. But firing the browser to point to port 40010 worked, showing that the DcsMaster has:
Listener37800:100
sandbox.local <http://sandbox.local:40031> 1 Sun Jun 21 02:00:05 PDT 2015 YES CONNECTED 0 22787 $Z000IL2 10.0.1.38 37803 sandbox TrafCI 10.0.1.38
55550 Sun Jun 21 02:00:05 PDT 2015 YES AVAILABLE 0 22626 $Z000IGG 10.0.1.38
37802
When JIRA is available, I will create an improvement issue to include the dcs.master.info.port in dcs-site.xml (it is better to have it in for and improved user experience), and will provide a patch subsequently.
So I tried to telnet into port 37800 from my host to the sandbox vm, and it succeeded. However, logs showed no indication of any connection from host to guest vm.
Best regards,
Pierre Smits
*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com
On Sun, Jun 21, 2015 at 3:33 AM, Subbiah, Suresh <Su...@hp.com>
wrote:
> Hi Pierre,
>
> Thanks for checking.
>
> Let's try a few more things.
>
> 1) does "sqps" show mxosrvr processes
> 2) If yes, can you please type "trafci" from the shell. Trafci is a
> JDBC
> T4 client that ships with Trafodion. It will be interesting to see if
> this can connect.
> 3) I am not sure what the default value for dcs.master.info.port is.
> If you can find it from dcs*/conf/dcs-site.xml, then we can use the
> web interface to see the status of the connection. From within the
> sandbox , use a browser to point to the address localhost:<dcs.master.info.port> .
> This port number will be close to 37800 port used to make a jdbc connection.
> 4) If none of this works, we can also try the logs described in
> http://docs.trafodion.org/dcs_docs/index.html#troubleshooting
>
> Thank you
> Suresh
>
>
>
>
> -----Original Message-----
> From: Pierre Smits [mailto:pierre.smits@gmail.com]
> Sent: Saturday, June 20, 2015 7:18 PM
> To: dev@trafodion.incubator.apache.org
> Subject: Re: Manual installation of Trafodion
>
> Hi Suresh,
>
> Yes, all Trafodion processes were started. Had the check done before I
> started OFBiz to load some seed data (which starts with creating the
> tables). And sqlci gave me the notification that Trafodion was already
> initialized.
>
> Thank you for your time.
>
> Best regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
> On Sun, Jun 21, 2015 at 2:08 AM, Subbiah, Suresh
> <Su...@hp.com>
> wrote:
>
> > Hi Pierre,
> >
> > One approach here is to determine if Trafodion is started and
> > functioning correctly on the sandbox before we connect to it.
> > Could you please get on the sandbox and type "sqcheck". It should
> > show all the Trafodion processes that are up.
> >
> > If the output looks OK, you could start a "sqlci" session (an
> > interactive SQL session with Trafodion, on cluster, without
> > connectivity) And try a few commands. I think metadata tables will
> > need to be created with "initialize trafodion" if this has not been
> > done
> already.
> >
> > None of this maybe related to the connection problem, but it could
> > help isolate the issue.
> >
> > Thanks
> > Suresh
> >
> >
> > -----Original Message-----
> > From: Pierre Smits [mailto:pierre.smits@gmail.com]
> > Sent: Saturday, June 20, 2015 7:00 PM
> > To: dev@trafodion.incubator.apache.org
> > Subject: Re: Manual installation of Trafodion
> >
> > Hi Suresh,
> >
> > Thanks for the quick response.
> >
> > So I defined the connection as follows (for the connection to the
> > ofbiz namespace as follows:
> >
> > <datasource name="trafodion"
> > > add-missing-on-start="true"
> > > alias-view-columns="false"
> > > check-on-start="true"
> > > field-type-name="trafodion"
> > > helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> > > join-style="ansi"
> > > result-fetch-size="50"
> > > schema-name="ofbiz"
> > > use-binary-type-for-blob="true"
> > > use-fk-initially-deferred="false"
> > > use-order-by-nulls="true"
> > > >
> > > <read-data reader-name="seed"/>
> > > <read-data reader-name="seed-initial"/>
> > > <read-data reader-name="ext"/>
> > > <read-data reader-name="demo"/>
> > > <inline-jdbc
> > > jdbc-driver="org.trafodion.jdbc.t4.T4Driver"
> > > jdbc-uri="jdbc:t4jdbc://10.0.1.38:37800/ofbiz"
> > > jdbc-username="ofbiz"
> > > jdbc-password="ofbiz"
> > > isolation-level="ReadCommitted"
> > > pool-minsize="2"
> > > pool-maxsize="250"
> > > time-between-eviction-runs-millis="600000"/>
> > > </datasource>
> >
> >
> > Which is the common way to define the connection in OFBiz, and fired up.
> > And I got following errors (my apologies for the lengthiness):
> >
> > 2015-06-21 01:50:37,318 |OFBiz-batch-3 |GenericDelegator
> > |I| Delegator "default" initializing helper "trafodion" for entity
> > group "org.ofbiz".
> > 2015-06-21 01:50:37,318 |OFBiz-batch-1 |GenericDelegator
> > |I| Delegator "default" initializing helper "trafodiontenant" for
> > entity group "org.ofbiz.tenant".
> > 2015-06-21 01:50:37,318 |OFBiz-batch-2 |GenericDelegator
> > |I| Delegator "default" initializing helper "trafodionolap" for
> > entity group "org.ofbiz.olap".
> > 2015-06-21 01:50:37,324 |OFBiz-batch-3 |GenericDelegator
> > |I| Doing database check as requested in entityengine.xml with
> > addMissing=true
> > 2015-06-21 01:50:37,324 |OFBiz-batch-1 |GenericDelegator
> > |I| Doing database check as requested in entityengine.xml with
> > addMissing=true
> > 2015-06-21 01:50:37,324 |OFBiz-batch-2 |GenericDelegator
> > |I| Doing database check as requested in entityengine.xml with
> > addMissing=true
> > 2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
> > |E| Unable to establish a connection with the database for
> > helperName [trafodion]... Error was: java.sql.SQLException: Unable
> > to acquire a new connection from the pool
> > 2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
> > |E| Unable to establish a connection with the database, no
> > additional information available.
> > 2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
> > |E| Could not get table name information from the database, aborting.
> > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > |I| Database Product Name is Trafodion
> > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > |I| Database Product Version is 1.1
> > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > |I| Database Driver Name is org.trafodion.jdbc.t4.T4Driver
> > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > |I| Database Driver Version is Traf_JDBC_Type4_Build_17dd8d9
> > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > |I| Database Driver JDBC Version is 3.1
> > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > |I| Database Setting/Support Information (those with a * should be
> true):
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - supports transactions [true]*
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - isolation None [true]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - isolation ReadCommitted [true]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - isolation ReadUncommitted [true]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - isolation RepeatableRead [true]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - isolation Serializable [true]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - forward only type [true]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - scroll sensitive type [false]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - scroll insensitive type [true]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - is case sensitive [false]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - stores LowerCase [false]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - stores MixedCase [false]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - stores UpperCase [true]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - max table name length [128]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - max column name length [128]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - concurrent connections [0]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - concurrent statements [0]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - ANSI SQL92 Entry [true]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - ANSI SQL92 Intermediate [false]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - ANSI SQL92 Full [false]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - ODBC SQL Grammar Core [true]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - ODBC SQL Grammar Extended [false]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - ODBC SQL Grammar Minimum [true]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - outer joins [true]*
> > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > |I| - limited outer joins [true]
> > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > |I| - full outer joins [false]
> > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > |I| - group by [true]*
> > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > |I| - group by not in select [false]
> > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > |I| - column aliasing [true]
> > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > |I| - order by not in select [true]
> > 2015-06-21 01:50:42,811 |OFBiz-batch-2 |DatabaseUtil
> > |I| - alter table add column [false]*
> > 2015-06-21 01:50:42,811 |OFBiz-batch-2 |DatabaseUtil
> > |I| - non-nullable column [true]*
> > 2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
> > |I| - default fetchsize [100]
> > 2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
> > |I| - named parameters [ SKIPPED ]
> > 2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
> > |I| Getting Table Info From Database
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| Database Product Name is Trafodion
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| Database Product Version is 1.1
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| Database Driver Name is org.trafodion.jdbc.t4.T4Driver
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| Database Driver Version is Traf_JDBC_Type4_Build_17dd8d9
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| Database Driver JDBC Version is 3.1
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| Database Setting/Support Information (those with a * should be
> true):
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| - supports transactions [true]*
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| - isolation None [true]
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| - isolation ReadCommitted [true]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - isolation ReadUncommitted [true]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - isolation RepeatableRead [true]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - isolation Serializable [true]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - forward only type [true]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - scroll sensitive type [false]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - scroll insensitive type [true]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - is case sensitive [false]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - stores LowerCase [false]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - stores MixedCase [false]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - stores UpperCase [true]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - max table name length [128]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - max column name length [128]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - concurrent connections [0]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - concurrent statements [0]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - ANSI SQL92 Entry [true]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - ANSI SQL92 Intermediate [false]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - ANSI SQL92 Full [false]
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - ODBC SQL Grammar Core [true]
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - ODBC SQL Grammar Extended [false]
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - ODBC SQL Grammar Minimum [true]
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - outer joins [true]*
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - limited outer joins [true]
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - full outer joins [false]
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - group by [true]*
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - group by not in select [false]
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| - column aliasing [true]
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| - order by not in select [true]
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| - alter table add column [false]*
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| - non-nullable column [true]*
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| - default fetchsize [100]
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| - named parameters [ SKIPPED ]
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| Getting Table Info From Database
> > 2015-06-21 01:50:44,692 |OFBiz-batch-2 |DatabaseUtil
> > |W| Entity [CurrencyDimension] has no table in the database
> > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > |W| Entity [DateDimension] has no table in the database
> > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > |W| Entity [InventoryItemFact] has no table in the database
> > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > |W| Entity [ProductDimension] has no table in the database
> > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > |W| Entity [SalesInvoiceItemFact] has no table in the database
> > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > |W| Entity [SalesOrderItemFact] has no table in the database
> > 2015-06-21 01:50:44,722 |pool-2-thread-1 |DatabaseUtil
> > |E| Unable to establish a connection with the database for
> > helperName [trafodionolap]... Error was: java.sql.SQLException:
> > Unable to acquire a new connection from the pool
> > java.sql.SQLException: Unable to acquire a new connection from the
> > pool at
> >
> > org.apache.commons.dbcp2.managed.ManagedConnection.updateTransaction
> > St
> > atus(ManagedConnection.java:130)
> > ~[commons-dbcp2-2.1.jar:2.1]
> > at
> >
> > org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedCon
> > ne
> > ction.java:60)
> > ~[commons-dbcp2-2.1.jar:2.1]
> > at
> >
> > org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(Man
> > ag
> > edDataSource.java:82)
> > ~[commons-dbcp2-2.1.jar:2.1]
> > at
> >
> > org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCP
> > Co
> > nnectionFactory.java:63)
> > ~[ofbiz-entity.jar:?]
> > at
> >
> > org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(Geronimo
> > Tr
> > ansactionFactory.java:83)
> > ~[ofbiz-geronimo.jar:?]
> > at
> > org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:9
> > 6)
> > ~[ofbiz-entity.jar:?]
> > at
> > org.ofbiz.entity.jdbc.DatabaseUtil.createTable(DatabaseUtil.java:159
> > 1)
> > [ofbiz-entity.jar:?]
> > at
> >
> > org.ofbiz.entity.jdbc.DatabaseUtil$CreateTableCallable.call(Database
> > Ut
> > il.java:1529)
> > [ofbiz-entity.jar:?]
> > at
> >
> > org.ofbiz.entity.jdbc.DatabaseUtil$CreateTableCallable.call(Database
> > Ut
> > il.java:1515)
> > [ofbiz-entity.jar:?]
> > at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> > [?:1.8.0_45] at
> >
> > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor
> > .j
> > ava:1142)
> > [?:1.8.0_45]
> > at
> >
> > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.
> > java:617)
> > [?:1.8.0_45]
> > at java.lang.Thread.run(Thread.java:745) [?:1.8.0_45] Caused by:
> > org.trafodion.jdbc.t4.HPT4Exception: The message id:
> > as_connect_message_error With parameters: server handle not
> > available at
> >
> > org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.j
> > av
> > a:304)
> > ~[jdbcT4.jar:?]
> > at
> >
> > org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.j
> > av
> > a:238)
> > ~[jdbcT4.jar:?]
> > at
> >
> > org.trafodion.jdbc.t4.InterfaceConnection.connect(InterfaceConnection.
> > java:876)
> > ~[jdbcT4.jar:?]
> > at
> >
> > org.trafodion.jdbc.t4.InterfaceConnection.<init>(InterfaceConnection
> > .j
> > ava:173)
> > ~[jdbcT4.jar:?]
> > at
> >
> > org.trafodion.jdbc.t4.TrafT4Connection.makeConnection(TrafT4Connecti
> > on
> > .java:1608)
> > ~[jdbcT4.jar:?]
> > at
> > org.trafodion.jdbc.t4.TrafT4Connection.<init>(TrafT4Connection.java:
> > 15
> > 61)
> > ~[jdbcT4.jar:?]
> > at
> > org.trafodion.jdbc.t4.HPT4DataSource.getConnection(HPT4DataSource.ja
> > va
> > :129)
> > ~[jdbcT4.jar:?]
> > at
> > org.trafodion.jdbc.t4.HPT4DataSource.getConnection(HPT4DataSource.ja
> > va
> > :173)
> > ~[jdbcT4.jar:?]
> > at org.trafodion.jdbc.t4.T4Driver.connect(T4Driver.java:183)
> > ~[jdbcT4.jar:?]
> >
> >
> > And more...
> >
> > Do you perhaps have any ideas on how to resolve this?
> >
> > Best regards,
> >
> > Pierre Smits
> >
> > *ORRTIZ.COM <http://www.orrtiz.com>* Services & Solutions for Cloud-
> > Based Manufacturing, Professional Services and Retail & Trade
> > http://www.orrtiz.com
> >
>
Re: Manual installation of Trafodion
Posted by Pierre Smits <pi...@gmail.com>.
Hi Suresh, All,
After a restart with sqstart sqps showed that mxosrvr has 2 references.
And trafci was able to connect.
In dcs*/conf/dcs-site.xml no dcs.master.info.port configuration property
is available. But firing the browser to point to port 40010 worked, showing
that the DcsMaster has:
Listener37800:100
sandbox.local <http://sandbox.local:40031> 1 Sun Jun 21 02:00:05 PDT 2015
YES CONNECTED 0 22787 $Z000IL2 10.0.1.38 37803 sandbox TrafCI 10.0.1.38
55550 Sun Jun 21 02:00:05 PDT 2015 YES AVAILABLE 0 22626 $Z000IGG 10.0.1.38
37802
When JIRA is available, I will create an improvement issue to include the
dcs.master.info.port in dcs-site.xml (it is better to have it in for and
improved user experience), and will provide a patch subsequently.
So I tried to telnet into port 37800 from my host to the sandbox vm, and it
succeeded. However, logs showed no indication of any connection from host
to guest vm.
Best regards,
Pierre Smits
*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com
On Sun, Jun 21, 2015 at 3:33 AM, Subbiah, Suresh <Su...@hp.com>
wrote:
> Hi Pierre,
>
> Thanks for checking.
>
> Let's try a few more things.
>
> 1) does "sqps" show mxosrvr processes
> 2) If yes, can you please type "trafci" from the shell. Trafci is a JDBC
> T4 client that ships with Trafodion. It will be interesting to see if this
> can connect.
> 3) I am not sure what the default value for dcs.master.info.port is. If
> you can find it from dcs*/conf/dcs-site.xml, then we can use the web
> interface to see the status of the connection. From within the sandbox ,
> use a browser to point to the address localhost:<dcs.master.info.port> .
> This port number will be close to 37800 port used to make a jdbc connection.
> 4) If none of this works, we can also try the logs described in
> http://docs.trafodion.org/dcs_docs/index.html#troubleshooting
>
> Thank you
> Suresh
>
>
>
>
> -----Original Message-----
> From: Pierre Smits [mailto:pierre.smits@gmail.com]
> Sent: Saturday, June 20, 2015 7:18 PM
> To: dev@trafodion.incubator.apache.org
> Subject: Re: Manual installation of Trafodion
>
> Hi Suresh,
>
> Yes, all Trafodion processes were started. Had the check done before I
> started OFBiz to load some seed data (which starts with creating the
> tables). And sqlci gave me the notification that Trafodion was already
> initialized.
>
> Thank you for your time.
>
> Best regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
> On Sun, Jun 21, 2015 at 2:08 AM, Subbiah, Suresh <Su...@hp.com>
> wrote:
>
> > Hi Pierre,
> >
> > One approach here is to determine if Trafodion is started and
> > functioning correctly on the sandbox before we connect to it.
> > Could you please get on the sandbox and type "sqcheck". It should show
> > all the Trafodion processes that are up.
> >
> > If the output looks OK, you could start a "sqlci" session (an
> > interactive SQL session with Trafodion, on cluster, without
> > connectivity) And try a few commands. I think metadata tables will
> > need to be created with "initialize trafodion" if this has not been done
> already.
> >
> > None of this maybe related to the connection problem, but it could
> > help isolate the issue.
> >
> > Thanks
> > Suresh
> >
> >
> > -----Original Message-----
> > From: Pierre Smits [mailto:pierre.smits@gmail.com]
> > Sent: Saturday, June 20, 2015 7:00 PM
> > To: dev@trafodion.incubator.apache.org
> > Subject: Re: Manual installation of Trafodion
> >
> > Hi Suresh,
> >
> > Thanks for the quick response.
> >
> > So I defined the connection as follows (for the connection to the
> > ofbiz namespace as follows:
> >
> > <datasource name="trafodion"
> > > add-missing-on-start="true"
> > > alias-view-columns="false"
> > > check-on-start="true"
> > > field-type-name="trafodion"
> > > helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> > > join-style="ansi"
> > > result-fetch-size="50"
> > > schema-name="ofbiz"
> > > use-binary-type-for-blob="true"
> > > use-fk-initially-deferred="false"
> > > use-order-by-nulls="true"
> > > >
> > > <read-data reader-name="seed"/>
> > > <read-data reader-name="seed-initial"/>
> > > <read-data reader-name="ext"/>
> > > <read-data reader-name="demo"/>
> > > <inline-jdbc
> > > jdbc-driver="org.trafodion.jdbc.t4.T4Driver"
> > > jdbc-uri="jdbc:t4jdbc://10.0.1.38:37800/ofbiz"
> > > jdbc-username="ofbiz"
> > > jdbc-password="ofbiz"
> > > isolation-level="ReadCommitted"
> > > pool-minsize="2"
> > > pool-maxsize="250"
> > > time-between-eviction-runs-millis="600000"/>
> > > </datasource>
> >
> >
> > Which is the common way to define the connection in OFBiz, and fired up.
> > And I got following errors (my apologies for the lengthiness):
> >
> > 2015-06-21 01:50:37,318 |OFBiz-batch-3 |GenericDelegator
> > |I| Delegator "default" initializing helper "trafodion" for entity
> > group "org.ofbiz".
> > 2015-06-21 01:50:37,318 |OFBiz-batch-1 |GenericDelegator
> > |I| Delegator "default" initializing helper "trafodiontenant" for
> > entity group "org.ofbiz.tenant".
> > 2015-06-21 01:50:37,318 |OFBiz-batch-2 |GenericDelegator
> > |I| Delegator "default" initializing helper "trafodionolap" for
> > entity group "org.ofbiz.olap".
> > 2015-06-21 01:50:37,324 |OFBiz-batch-3 |GenericDelegator
> > |I| Doing database check as requested in entityengine.xml with
> > addMissing=true
> > 2015-06-21 01:50:37,324 |OFBiz-batch-1 |GenericDelegator
> > |I| Doing database check as requested in entityengine.xml with
> > addMissing=true
> > 2015-06-21 01:50:37,324 |OFBiz-batch-2 |GenericDelegator
> > |I| Doing database check as requested in entityengine.xml with
> > addMissing=true
> > 2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
> > |E| Unable to establish a connection with the database for helperName
> > [trafodion]... Error was: java.sql.SQLException: Unable to acquire a
> > new connection from the pool
> > 2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
> > |E| Unable to establish a connection with the database, no additional
> > information available.
> > 2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
> > |E| Could not get table name information from the database, aborting.
> > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > |I| Database Product Name is Trafodion
> > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > |I| Database Product Version is 1.1
> > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > |I| Database Driver Name is org.trafodion.jdbc.t4.T4Driver
> > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > |I| Database Driver Version is Traf_JDBC_Type4_Build_17dd8d9
> > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > |I| Database Driver JDBC Version is 3.1
> > 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> > |I| Database Setting/Support Information (those with a * should be
> true):
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - supports transactions [true]*
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - isolation None [true]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - isolation ReadCommitted [true]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - isolation ReadUncommitted [true]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - isolation RepeatableRead [true]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - isolation Serializable [true]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - forward only type [true]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - scroll sensitive type [false]
> > 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> > |I| - scroll insensitive type [true]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - is case sensitive [false]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - stores LowerCase [false]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - stores MixedCase [false]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - stores UpperCase [true]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - max table name length [128]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - max column name length [128]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - concurrent connections [0]
> > 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> > |I| - concurrent statements [0]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - ANSI SQL92 Entry [true]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - ANSI SQL92 Intermediate [false]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - ANSI SQL92 Full [false]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - ODBC SQL Grammar Core [true]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - ODBC SQL Grammar Extended [false]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - ODBC SQL Grammar Minimum [true]
> > 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> > |I| - outer joins [true]*
> > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > |I| - limited outer joins [true]
> > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > |I| - full outer joins [false]
> > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > |I| - group by [true]*
> > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > |I| - group by not in select [false]
> > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > |I| - column aliasing [true]
> > 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> > |I| - order by not in select [true]
> > 2015-06-21 01:50:42,811 |OFBiz-batch-2 |DatabaseUtil
> > |I| - alter table add column [false]*
> > 2015-06-21 01:50:42,811 |OFBiz-batch-2 |DatabaseUtil
> > |I| - non-nullable column [true]*
> > 2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
> > |I| - default fetchsize [100]
> > 2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
> > |I| - named parameters [ SKIPPED ]
> > 2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
> > |I| Getting Table Info From Database
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| Database Product Name is Trafodion
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| Database Product Version is 1.1
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| Database Driver Name is org.trafodion.jdbc.t4.T4Driver
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| Database Driver Version is Traf_JDBC_Type4_Build_17dd8d9
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| Database Driver JDBC Version is 3.1
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| Database Setting/Support Information (those with a * should be
> true):
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| - supports transactions [true]*
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| - isolation None [true]
> > 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> > |I| - isolation ReadCommitted [true]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - isolation ReadUncommitted [true]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - isolation RepeatableRead [true]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - isolation Serializable [true]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - forward only type [true]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - scroll sensitive type [false]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - scroll insensitive type [true]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - is case sensitive [false]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - stores LowerCase [false]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - stores MixedCase [false]
> > 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> > |I| - stores UpperCase [true]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - max table name length [128]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - max column name length [128]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - concurrent connections [0]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - concurrent statements [0]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - ANSI SQL92 Entry [true]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - ANSI SQL92 Intermediate [false]
> > 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> > |I| - ANSI SQL92 Full [false]
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - ODBC SQL Grammar Core [true]
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - ODBC SQL Grammar Extended [false]
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - ODBC SQL Grammar Minimum [true]
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - outer joins [true]*
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - limited outer joins [true]
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - full outer joins [false]
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - group by [true]*
> > 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> > |I| - group by not in select [false]
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| - column aliasing [true]
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| - order by not in select [true]
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| - alter table add column [false]*
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| - non-nullable column [true]*
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| - default fetchsize [100]
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| - named parameters [ SKIPPED ]
> > 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> > |I| Getting Table Info From Database
> > 2015-06-21 01:50:44,692 |OFBiz-batch-2 |DatabaseUtil
> > |W| Entity [CurrencyDimension] has no table in the database
> > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > |W| Entity [DateDimension] has no table in the database
> > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > |W| Entity [InventoryItemFact] has no table in the database
> > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > |W| Entity [ProductDimension] has no table in the database
> > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > |W| Entity [SalesInvoiceItemFact] has no table in the database
> > 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> > |W| Entity [SalesOrderItemFact] has no table in the database
> > 2015-06-21 01:50:44,722 |pool-2-thread-1 |DatabaseUtil
> > |E| Unable to establish a connection with the database for helperName
> > [trafodionolap]... Error was: java.sql.SQLException: Unable to acquire
> > a new connection from the pool
> > java.sql.SQLException: Unable to acquire a new connection from the
> > pool at
> >
> > org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionSt
> > atus(ManagedConnection.java:130)
> > ~[commons-dbcp2-2.1.jar:2.1]
> > at
> >
> > org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConne
> > ction.java:60)
> > ~[commons-dbcp2-2.1.jar:2.1]
> > at
> >
> > org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(Manag
> > edDataSource.java:82)
> > ~[commons-dbcp2-2.1.jar:2.1]
> > at
> >
> > org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPCo
> > nnectionFactory.java:63)
> > ~[ofbiz-entity.jar:?]
> > at
> >
> > org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTr
> > ansactionFactory.java:83)
> > ~[ofbiz-geronimo.jar:?]
> > at
> > org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:96)
> > ~[ofbiz-entity.jar:?]
> > at
> > org.ofbiz.entity.jdbc.DatabaseUtil.createTable(DatabaseUtil.java:1591)
> > [ofbiz-entity.jar:?]
> > at
> >
> > org.ofbiz.entity.jdbc.DatabaseUtil$CreateTableCallable.call(DatabaseUt
> > il.java:1529)
> > [ofbiz-entity.jar:?]
> > at
> >
> > org.ofbiz.entity.jdbc.DatabaseUtil$CreateTableCallable.call(DatabaseUt
> > il.java:1515)
> > [ofbiz-entity.jar:?]
> > at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> > [?:1.8.0_45] at
> >
> > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.j
> > ava:1142)
> > [?:1.8.0_45]
> > at
> >
> > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.
> > java:617)
> > [?:1.8.0_45]
> > at java.lang.Thread.run(Thread.java:745) [?:1.8.0_45] Caused by:
> > org.trafodion.jdbc.t4.HPT4Exception: The message id:
> > as_connect_message_error With parameters: server handle not available
> > at
> >
> > org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.jav
> > a:304)
> > ~[jdbcT4.jar:?]
> > at
> >
> > org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.jav
> > a:238)
> > ~[jdbcT4.jar:?]
> > at
> >
> > org.trafodion.jdbc.t4.InterfaceConnection.connect(InterfaceConnection.
> > java:876)
> > ~[jdbcT4.jar:?]
> > at
> >
> > org.trafodion.jdbc.t4.InterfaceConnection.<init>(InterfaceConnection.j
> > ava:173)
> > ~[jdbcT4.jar:?]
> > at
> >
> > org.trafodion.jdbc.t4.TrafT4Connection.makeConnection(TrafT4Connection
> > .java:1608)
> > ~[jdbcT4.jar:?]
> > at
> > org.trafodion.jdbc.t4.TrafT4Connection.<init>(TrafT4Connection.java:15
> > 61)
> > ~[jdbcT4.jar:?]
> > at
> > org.trafodion.jdbc.t4.HPT4DataSource.getConnection(HPT4DataSource.java
> > :129)
> > ~[jdbcT4.jar:?]
> > at
> > org.trafodion.jdbc.t4.HPT4DataSource.getConnection(HPT4DataSource.java
> > :173)
> > ~[jdbcT4.jar:?]
> > at org.trafodion.jdbc.t4.T4Driver.connect(T4Driver.java:183)
> > ~[jdbcT4.jar:?]
> >
> >
> > And more...
> >
> > Do you perhaps have any ideas on how to resolve this?
> >
> > Best regards,
> >
> > Pierre Smits
> >
> > *ORRTIZ.COM <http://www.orrtiz.com>*
> > Services & Solutions for Cloud-
> > Based Manufacturing, Professional
> > Services and Retail & Trade
> > http://www.orrtiz.com
> >
>
RE: Manual installation of Trafodion
Posted by "Subbiah, Suresh" <Su...@hp.com>.
Hi Pierre,
Thanks for checking.
Let's try a few more things.
1) does "sqps" show mxosrvr processes
2) If yes, can you please type "trafci" from the shell. Trafci is a JDBC T4 client that ships with Trafodion. It will be interesting to see if this can connect.
3) I am not sure what the default value for dcs.master.info.port is. If you can find it from dcs*/conf/dcs-site.xml, then we can use the web interface to see the status of the connection. From within the sandbox , use a browser to point to the address localhost:<dcs.master.info.port> . This port number will be close to 37800 port used to make a jdbc connection.
4) If none of this works, we can also try the logs described in http://docs.trafodion.org/dcs_docs/index.html#troubleshooting
Thank you
Suresh
-----Original Message-----
From: Pierre Smits [mailto:pierre.smits@gmail.com]
Sent: Saturday, June 20, 2015 7:18 PM
To: dev@trafodion.incubator.apache.org
Subject: Re: Manual installation of Trafodion
Hi Suresh,
Yes, all Trafodion processes were started. Had the check done before I started OFBiz to load some seed data (which starts with creating the tables). And sqlci gave me the notification that Trafodion was already initialized.
Thank you for your time.
Best regards,
Pierre Smits
*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com
On Sun, Jun 21, 2015 at 2:08 AM, Subbiah, Suresh <Su...@hp.com>
wrote:
> Hi Pierre,
>
> One approach here is to determine if Trafodion is started and
> functioning correctly on the sandbox before we connect to it.
> Could you please get on the sandbox and type "sqcheck". It should show
> all the Trafodion processes that are up.
>
> If the output looks OK, you could start a "sqlci" session (an
> interactive SQL session with Trafodion, on cluster, without
> connectivity) And try a few commands. I think metadata tables will
> need to be created with "initialize trafodion" if this has not been done already.
>
> None of this maybe related to the connection problem, but it could
> help isolate the issue.
>
> Thanks
> Suresh
>
>
> -----Original Message-----
> From: Pierre Smits [mailto:pierre.smits@gmail.com]
> Sent: Saturday, June 20, 2015 7:00 PM
> To: dev@trafodion.incubator.apache.org
> Subject: Re: Manual installation of Trafodion
>
> Hi Suresh,
>
> Thanks for the quick response.
>
> So I defined the connection as follows (for the connection to the
> ofbiz namespace as follows:
>
> <datasource name="trafodion"
> > add-missing-on-start="true"
> > alias-view-columns="false"
> > check-on-start="true"
> > field-type-name="trafodion"
> > helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> > join-style="ansi"
> > result-fetch-size="50"
> > schema-name="ofbiz"
> > use-binary-type-for-blob="true"
> > use-fk-initially-deferred="false"
> > use-order-by-nulls="true"
> > >
> > <read-data reader-name="seed"/>
> > <read-data reader-name="seed-initial"/>
> > <read-data reader-name="ext"/>
> > <read-data reader-name="demo"/>
> > <inline-jdbc
> > jdbc-driver="org.trafodion.jdbc.t4.T4Driver"
> > jdbc-uri="jdbc:t4jdbc://10.0.1.38:37800/ofbiz"
> > jdbc-username="ofbiz"
> > jdbc-password="ofbiz"
> > isolation-level="ReadCommitted"
> > pool-minsize="2"
> > pool-maxsize="250"
> > time-between-eviction-runs-millis="600000"/>
> > </datasource>
>
>
> Which is the common way to define the connection in OFBiz, and fired up.
> And I got following errors (my apologies for the lengthiness):
>
> 2015-06-21 01:50:37,318 |OFBiz-batch-3 |GenericDelegator
> |I| Delegator "default" initializing helper "trafodion" for entity
> group "org.ofbiz".
> 2015-06-21 01:50:37,318 |OFBiz-batch-1 |GenericDelegator
> |I| Delegator "default" initializing helper "trafodiontenant" for
> entity group "org.ofbiz.tenant".
> 2015-06-21 01:50:37,318 |OFBiz-batch-2 |GenericDelegator
> |I| Delegator "default" initializing helper "trafodionolap" for
> entity group "org.ofbiz.olap".
> 2015-06-21 01:50:37,324 |OFBiz-batch-3 |GenericDelegator
> |I| Doing database check as requested in entityengine.xml with
> addMissing=true
> 2015-06-21 01:50:37,324 |OFBiz-batch-1 |GenericDelegator
> |I| Doing database check as requested in entityengine.xml with
> addMissing=true
> 2015-06-21 01:50:37,324 |OFBiz-batch-2 |GenericDelegator
> |I| Doing database check as requested in entityengine.xml with
> addMissing=true
> 2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
> |E| Unable to establish a connection with the database for helperName
> [trafodion]... Error was: java.sql.SQLException: Unable to acquire a
> new connection from the pool
> 2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
> |E| Unable to establish a connection with the database, no additional
> information available.
> 2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
> |E| Could not get table name information from the database, aborting.
> 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> |I| Database Product Name is Trafodion
> 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> |I| Database Product Version is 1.1
> 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> |I| Database Driver Name is org.trafodion.jdbc.t4.T4Driver
> 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> |I| Database Driver Version is Traf_JDBC_Type4_Build_17dd8d9
> 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> |I| Database Driver JDBC Version is 3.1
> 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> |I| Database Setting/Support Information (those with a * should be true):
> 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> |I| - supports transactions [true]*
> 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> |I| - isolation None [true]
> 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> |I| - isolation ReadCommitted [true]
> 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> |I| - isolation ReadUncommitted [true]
> 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> |I| - isolation RepeatableRead [true]
> 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> |I| - isolation Serializable [true]
> 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> |I| - forward only type [true]
> 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> |I| - scroll sensitive type [false]
> 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> |I| - scroll insensitive type [true]
> 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> |I| - is case sensitive [false]
> 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> |I| - stores LowerCase [false]
> 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> |I| - stores MixedCase [false]
> 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> |I| - stores UpperCase [true]
> 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> |I| - max table name length [128]
> 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> |I| - max column name length [128]
> 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> |I| - concurrent connections [0]
> 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> |I| - concurrent statements [0]
> 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> |I| - ANSI SQL92 Entry [true]
> 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> |I| - ANSI SQL92 Intermediate [false]
> 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> |I| - ANSI SQL92 Full [false]
> 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> |I| - ODBC SQL Grammar Core [true]
> 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> |I| - ODBC SQL Grammar Extended [false]
> 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> |I| - ODBC SQL Grammar Minimum [true]
> 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> |I| - outer joins [true]*
> 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> |I| - limited outer joins [true]
> 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> |I| - full outer joins [false]
> 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> |I| - group by [true]*
> 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> |I| - group by not in select [false]
> 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> |I| - column aliasing [true]
> 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> |I| - order by not in select [true]
> 2015-06-21 01:50:42,811 |OFBiz-batch-2 |DatabaseUtil
> |I| - alter table add column [false]*
> 2015-06-21 01:50:42,811 |OFBiz-batch-2 |DatabaseUtil
> |I| - non-nullable column [true]*
> 2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
> |I| - default fetchsize [100]
> 2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
> |I| - named parameters [ SKIPPED ]
> 2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
> |I| Getting Table Info From Database
> 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> |I| Database Product Name is Trafodion
> 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> |I| Database Product Version is 1.1
> 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> |I| Database Driver Name is org.trafodion.jdbc.t4.T4Driver
> 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> |I| Database Driver Version is Traf_JDBC_Type4_Build_17dd8d9
> 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> |I| Database Driver JDBC Version is 3.1
> 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> |I| Database Setting/Support Information (those with a * should be true):
> 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> |I| - supports transactions [true]*
> 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> |I| - isolation None [true]
> 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> |I| - isolation ReadCommitted [true]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - isolation ReadUncommitted [true]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - isolation RepeatableRead [true]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - isolation Serializable [true]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - forward only type [true]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - scroll sensitive type [false]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - scroll insensitive type [true]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - is case sensitive [false]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - stores LowerCase [false]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - stores MixedCase [false]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - stores UpperCase [true]
> 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> |I| - max table name length [128]
> 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> |I| - max column name length [128]
> 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> |I| - concurrent connections [0]
> 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> |I| - concurrent statements [0]
> 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> |I| - ANSI SQL92 Entry [true]
> 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> |I| - ANSI SQL92 Intermediate [false]
> 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> |I| - ANSI SQL92 Full [false]
> 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> |I| - ODBC SQL Grammar Core [true]
> 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> |I| - ODBC SQL Grammar Extended [false]
> 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> |I| - ODBC SQL Grammar Minimum [true]
> 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> |I| - outer joins [true]*
> 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> |I| - limited outer joins [true]
> 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> |I| - full outer joins [false]
> 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> |I| - group by [true]*
> 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> |I| - group by not in select [false]
> 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> |I| - column aliasing [true]
> 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> |I| - order by not in select [true]
> 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> |I| - alter table add column [false]*
> 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> |I| - non-nullable column [true]*
> 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> |I| - default fetchsize [100]
> 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> |I| - named parameters [ SKIPPED ]
> 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> |I| Getting Table Info From Database
> 2015-06-21 01:50:44,692 |OFBiz-batch-2 |DatabaseUtil
> |W| Entity [CurrencyDimension] has no table in the database
> 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> |W| Entity [DateDimension] has no table in the database
> 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> |W| Entity [InventoryItemFact] has no table in the database
> 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> |W| Entity [ProductDimension] has no table in the database
> 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> |W| Entity [SalesInvoiceItemFact] has no table in the database
> 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> |W| Entity [SalesOrderItemFact] has no table in the database
> 2015-06-21 01:50:44,722 |pool-2-thread-1 |DatabaseUtil
> |E| Unable to establish a connection with the database for helperName
> [trafodionolap]... Error was: java.sql.SQLException: Unable to acquire
> a new connection from the pool
> java.sql.SQLException: Unable to acquire a new connection from the
> pool at
>
> org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionSt
> atus(ManagedConnection.java:130)
> ~[commons-dbcp2-2.1.jar:2.1]
> at
>
> org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConne
> ction.java:60)
> ~[commons-dbcp2-2.1.jar:2.1]
> at
>
> org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(Manag
> edDataSource.java:82)
> ~[commons-dbcp2-2.1.jar:2.1]
> at
>
> org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPCo
> nnectionFactory.java:63)
> ~[ofbiz-entity.jar:?]
> at
>
> org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTr
> ansactionFactory.java:83)
> ~[ofbiz-geronimo.jar:?]
> at
> org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:96)
> ~[ofbiz-entity.jar:?]
> at
> org.ofbiz.entity.jdbc.DatabaseUtil.createTable(DatabaseUtil.java:1591)
> [ofbiz-entity.jar:?]
> at
>
> org.ofbiz.entity.jdbc.DatabaseUtil$CreateTableCallable.call(DatabaseUt
> il.java:1529)
> [ofbiz-entity.jar:?]
> at
>
> org.ofbiz.entity.jdbc.DatabaseUtil$CreateTableCallable.call(DatabaseUt
> il.java:1515)
> [ofbiz-entity.jar:?]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> [?:1.8.0_45] at
>
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.j
> ava:1142)
> [?:1.8.0_45]
> at
>
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.
> java:617)
> [?:1.8.0_45]
> at java.lang.Thread.run(Thread.java:745) [?:1.8.0_45] Caused by:
> org.trafodion.jdbc.t4.HPT4Exception: The message id:
> as_connect_message_error With parameters: server handle not available
> at
>
> org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.jav
> a:304)
> ~[jdbcT4.jar:?]
> at
>
> org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.jav
> a:238)
> ~[jdbcT4.jar:?]
> at
>
> org.trafodion.jdbc.t4.InterfaceConnection.connect(InterfaceConnection.
> java:876)
> ~[jdbcT4.jar:?]
> at
>
> org.trafodion.jdbc.t4.InterfaceConnection.<init>(InterfaceConnection.j
> ava:173)
> ~[jdbcT4.jar:?]
> at
>
> org.trafodion.jdbc.t4.TrafT4Connection.makeConnection(TrafT4Connection
> .java:1608)
> ~[jdbcT4.jar:?]
> at
> org.trafodion.jdbc.t4.TrafT4Connection.<init>(TrafT4Connection.java:15
> 61)
> ~[jdbcT4.jar:?]
> at
> org.trafodion.jdbc.t4.HPT4DataSource.getConnection(HPT4DataSource.java
> :129)
> ~[jdbcT4.jar:?]
> at
> org.trafodion.jdbc.t4.HPT4DataSource.getConnection(HPT4DataSource.java
> :173)
> ~[jdbcT4.jar:?]
> at org.trafodion.jdbc.t4.T4Driver.connect(T4Driver.java:183)
> ~[jdbcT4.jar:?]
>
>
> And more...
>
> Do you perhaps have any ideas on how to resolve this?
>
> Best regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
Re: Manual installation of Trafodion
Posted by Pierre Smits <pi...@gmail.com>.
Hi Suresh,
Yes, all Trafodion processes were started. Had the check done before I
started OFBiz to load some seed data (which starts with creating the
tables). And sqlci gave me the notification that Trafodion was already
initialized.
Thank you for your time.
Best regards,
Pierre Smits
*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com
On Sun, Jun 21, 2015 at 2:08 AM, Subbiah, Suresh <Su...@hp.com>
wrote:
> Hi Pierre,
>
> One approach here is to determine if Trafodion is started and functioning
> correctly on the sandbox before we connect to it.
> Could you please get on the sandbox and type "sqcheck". It should show all
> the Trafodion processes that are up.
>
> If the output looks OK, you could start a "sqlci" session (an interactive
> SQL session with Trafodion, on cluster, without connectivity)
> And try a few commands. I think metadata tables will need to be created
> with "initialize trafodion" if this has not been done already.
>
> None of this maybe related to the connection problem, but it could help
> isolate the issue.
>
> Thanks
> Suresh
>
>
> -----Original Message-----
> From: Pierre Smits [mailto:pierre.smits@gmail.com]
> Sent: Saturday, June 20, 2015 7:00 PM
> To: dev@trafodion.incubator.apache.org
> Subject: Re: Manual installation of Trafodion
>
> Hi Suresh,
>
> Thanks for the quick response.
>
> So I defined the connection as follows (for the connection to the ofbiz
> namespace as follows:
>
> <datasource name="trafodion"
> > add-missing-on-start="true"
> > alias-view-columns="false"
> > check-on-start="true"
> > field-type-name="trafodion"
> > helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> > join-style="ansi"
> > result-fetch-size="50"
> > schema-name="ofbiz"
> > use-binary-type-for-blob="true"
> > use-fk-initially-deferred="false"
> > use-order-by-nulls="true"
> > >
> > <read-data reader-name="seed"/>
> > <read-data reader-name="seed-initial"/>
> > <read-data reader-name="ext"/>
> > <read-data reader-name="demo"/>
> > <inline-jdbc
> > jdbc-driver="org.trafodion.jdbc.t4.T4Driver"
> > jdbc-uri="jdbc:t4jdbc://10.0.1.38:37800/ofbiz"
> > jdbc-username="ofbiz"
> > jdbc-password="ofbiz"
> > isolation-level="ReadCommitted"
> > pool-minsize="2"
> > pool-maxsize="250"
> > time-between-eviction-runs-millis="600000"/>
> > </datasource>
>
>
> Which is the common way to define the connection in OFBiz, and fired up.
> And I got following errors (my apologies for the lengthiness):
>
> 2015-06-21 01:50:37,318 |OFBiz-batch-3 |GenericDelegator
> |I| Delegator "default" initializing helper "trafodion" for entity group
> "org.ofbiz".
> 2015-06-21 01:50:37,318 |OFBiz-batch-1 |GenericDelegator
> |I| Delegator "default" initializing helper "trafodiontenant" for entity
> group "org.ofbiz.tenant".
> 2015-06-21 01:50:37,318 |OFBiz-batch-2 |GenericDelegator
> |I| Delegator "default" initializing helper "trafodionolap" for entity
> group "org.ofbiz.olap".
> 2015-06-21 01:50:37,324 |OFBiz-batch-3 |GenericDelegator
> |I| Doing database check as requested in entityengine.xml with
> addMissing=true
> 2015-06-21 01:50:37,324 |OFBiz-batch-1 |GenericDelegator
> |I| Doing database check as requested in entityengine.xml with
> addMissing=true
> 2015-06-21 01:50:37,324 |OFBiz-batch-2 |GenericDelegator
> |I| Doing database check as requested in entityengine.xml with
> addMissing=true
> 2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
> |E| Unable to establish a connection with the database for helperName
> [trafodion]... Error was: java.sql.SQLException: Unable to acquire a new
> connection from the pool
> 2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
> |E| Unable to establish a connection with the database, no additional
> information available.
> 2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
> |E| Could not get table name information from the database, aborting.
> 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> |I| Database Product Name is Trafodion
> 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> |I| Database Product Version is 1.1
> 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> |I| Database Driver Name is org.trafodion.jdbc.t4.T4Driver
> 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> |I| Database Driver Version is Traf_JDBC_Type4_Build_17dd8d9
> 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> |I| Database Driver JDBC Version is 3.1
> 2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
> |I| Database Setting/Support Information (those with a * should be true):
> 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> |I| - supports transactions [true]*
> 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> |I| - isolation None [true]
> 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> |I| - isolation ReadCommitted [true]
> 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> |I| - isolation ReadUncommitted [true]
> 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> |I| - isolation RepeatableRead [true]
> 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> |I| - isolation Serializable [true]
> 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> |I| - forward only type [true]
> 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> |I| - scroll sensitive type [false]
> 2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
> |I| - scroll insensitive type [true]
> 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> |I| - is case sensitive [false]
> 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> |I| - stores LowerCase [false]
> 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> |I| - stores MixedCase [false]
> 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> |I| - stores UpperCase [true]
> 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> |I| - max table name length [128]
> 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> |I| - max column name length [128]
> 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> |I| - concurrent connections [0]
> 2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
> |I| - concurrent statements [0]
> 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> |I| - ANSI SQL92 Entry [true]
> 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> |I| - ANSI SQL92 Intermediate [false]
> 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> |I| - ANSI SQL92 Full [false]
> 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> |I| - ODBC SQL Grammar Core [true]
> 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> |I| - ODBC SQL Grammar Extended [false]
> 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> |I| - ODBC SQL Grammar Minimum [true]
> 2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
> |I| - outer joins [true]*
> 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> |I| - limited outer joins [true]
> 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> |I| - full outer joins [false]
> 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> |I| - group by [true]*
> 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> |I| - group by not in select [false]
> 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> |I| - column aliasing [true]
> 2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
> |I| - order by not in select [true]
> 2015-06-21 01:50:42,811 |OFBiz-batch-2 |DatabaseUtil
> |I| - alter table add column [false]*
> 2015-06-21 01:50:42,811 |OFBiz-batch-2 |DatabaseUtil
> |I| - non-nullable column [true]*
> 2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
> |I| - default fetchsize [100]
> 2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
> |I| - named parameters [ SKIPPED ]
> 2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
> |I| Getting Table Info From Database
> 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> |I| Database Product Name is Trafodion
> 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> |I| Database Product Version is 1.1
> 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> |I| Database Driver Name is org.trafodion.jdbc.t4.T4Driver
> 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> |I| Database Driver Version is Traf_JDBC_Type4_Build_17dd8d9
> 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> |I| Database Driver JDBC Version is 3.1
> 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> |I| Database Setting/Support Information (those with a * should be true):
> 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> |I| - supports transactions [true]*
> 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> |I| - isolation None [true]
> 2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
> |I| - isolation ReadCommitted [true]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - isolation ReadUncommitted [true]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - isolation RepeatableRead [true]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - isolation Serializable [true]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - forward only type [true]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - scroll sensitive type [false]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - scroll insensitive type [true]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - is case sensitive [false]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - stores LowerCase [false]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - stores MixedCase [false]
> 2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
> |I| - stores UpperCase [true]
> 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> |I| - max table name length [128]
> 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> |I| - max column name length [128]
> 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> |I| - concurrent connections [0]
> 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> |I| - concurrent statements [0]
> 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> |I| - ANSI SQL92 Entry [true]
> 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> |I| - ANSI SQL92 Intermediate [false]
> 2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
> |I| - ANSI SQL92 Full [false]
> 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> |I| - ODBC SQL Grammar Core [true]
> 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> |I| - ODBC SQL Grammar Extended [false]
> 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> |I| - ODBC SQL Grammar Minimum [true]
> 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> |I| - outer joins [true]*
> 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> |I| - limited outer joins [true]
> 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> |I| - full outer joins [false]
> 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> |I| - group by [true]*
> 2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
> |I| - group by not in select [false]
> 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> |I| - column aliasing [true]
> 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> |I| - order by not in select [true]
> 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> |I| - alter table add column [false]*
> 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> |I| - non-nullable column [true]*
> 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> |I| - default fetchsize [100]
> 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> |I| - named parameters [ SKIPPED ]
> 2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
> |I| Getting Table Info From Database
> 2015-06-21 01:50:44,692 |OFBiz-batch-2 |DatabaseUtil
> |W| Entity [CurrencyDimension] has no table in the database
> 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> |W| Entity [DateDimension] has no table in the database
> 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> |W| Entity [InventoryItemFact] has no table in the database
> 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> |W| Entity [ProductDimension] has no table in the database
> 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> |W| Entity [SalesInvoiceItemFact] has no table in the database
> 2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
> |W| Entity [SalesOrderItemFact] has no table in the database
> 2015-06-21 01:50:44,722 |pool-2-thread-1 |DatabaseUtil
> |E| Unable to establish a connection with the database for helperName
> [trafodionolap]... Error was: java.sql.SQLException: Unable to acquire a
> new connection from the pool
> java.sql.SQLException: Unable to acquire a new connection from the pool at
>
> org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:130)
> ~[commons-dbcp2-2.1.jar:2.1]
> at
>
> org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:60)
> ~[commons-dbcp2-2.1.jar:2.1]
> at
>
> org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:82)
> ~[commons-dbcp2-2.1.jar:2.1]
> at
>
> org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:63)
> ~[ofbiz-entity.jar:?]
> at
>
> org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:83)
> ~[ofbiz-geronimo.jar:?]
> at org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:96)
> ~[ofbiz-entity.jar:?]
> at org.ofbiz.entity.jdbc.DatabaseUtil.createTable(DatabaseUtil.java:1591)
> [ofbiz-entity.jar:?]
> at
>
> org.ofbiz.entity.jdbc.DatabaseUtil$CreateTableCallable.call(DatabaseUtil.java:1529)
> [ofbiz-entity.jar:?]
> at
>
> org.ofbiz.entity.jdbc.DatabaseUtil$CreateTableCallable.call(DatabaseUtil.java:1515)
> [ofbiz-entity.jar:?]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_45] at
>
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> [?:1.8.0_45]
> at
>
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> [?:1.8.0_45]
> at java.lang.Thread.run(Thread.java:745) [?:1.8.0_45] Caused by:
> org.trafodion.jdbc.t4.HPT4Exception: The message id:
> as_connect_message_error With parameters: server handle not available at
>
> org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.java:304)
> ~[jdbcT4.jar:?]
> at
>
> org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.java:238)
> ~[jdbcT4.jar:?]
> at
>
> org.trafodion.jdbc.t4.InterfaceConnection.connect(InterfaceConnection.java:876)
> ~[jdbcT4.jar:?]
> at
>
> org.trafodion.jdbc.t4.InterfaceConnection.<init>(InterfaceConnection.java:173)
> ~[jdbcT4.jar:?]
> at
>
> org.trafodion.jdbc.t4.TrafT4Connection.makeConnection(TrafT4Connection.java:1608)
> ~[jdbcT4.jar:?]
> at
> org.trafodion.jdbc.t4.TrafT4Connection.<init>(TrafT4Connection.java:1561)
> ~[jdbcT4.jar:?]
> at
> org.trafodion.jdbc.t4.HPT4DataSource.getConnection(HPT4DataSource.java:129)
> ~[jdbcT4.jar:?]
> at
> org.trafodion.jdbc.t4.HPT4DataSource.getConnection(HPT4DataSource.java:173)
> ~[jdbcT4.jar:?]
> at org.trafodion.jdbc.t4.T4Driver.connect(T4Driver.java:183)
> ~[jdbcT4.jar:?]
>
>
> And more...
>
> Do you perhaps have any ideas on how to resolve this?
>
> Best regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
RE: Manual installation of Trafodion
Posted by "Subbiah, Suresh" <Su...@hp.com>.
Hi Pierre,
One approach here is to determine if Trafodion is started and functioning correctly on the sandbox before we connect to it.
Could you please get on the sandbox and type "sqcheck". It should show all the Trafodion processes that are up.
If the output looks OK, you could start a "sqlci" session (an interactive SQL session with Trafodion, on cluster, without connectivity)
And try a few commands. I think metadata tables will need to be created with "initialize trafodion" if this has not been done already.
None of this maybe related to the connection problem, but it could help isolate the issue.
Thanks
Suresh
-----Original Message-----
From: Pierre Smits [mailto:pierre.smits@gmail.com]
Sent: Saturday, June 20, 2015 7:00 PM
To: dev@trafodion.incubator.apache.org
Subject: Re: Manual installation of Trafodion
Hi Suresh,
Thanks for the quick response.
So I defined the connection as follows (for the connection to the ofbiz namespace as follows:
<datasource name="trafodion"
> add-missing-on-start="true"
> alias-view-columns="false"
> check-on-start="true"
> field-type-name="trafodion"
> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> join-style="ansi"
> result-fetch-size="50"
> schema-name="ofbiz"
> use-binary-type-for-blob="true"
> use-fk-initially-deferred="false"
> use-order-by-nulls="true"
> >
> <read-data reader-name="seed"/>
> <read-data reader-name="seed-initial"/>
> <read-data reader-name="ext"/>
> <read-data reader-name="demo"/>
> <inline-jdbc
> jdbc-driver="org.trafodion.jdbc.t4.T4Driver"
> jdbc-uri="jdbc:t4jdbc://10.0.1.38:37800/ofbiz"
> jdbc-username="ofbiz"
> jdbc-password="ofbiz"
> isolation-level="ReadCommitted"
> pool-minsize="2"
> pool-maxsize="250"
> time-between-eviction-runs-millis="600000"/>
> </datasource>
Which is the common way to define the connection in OFBiz, and fired up.
And I got following errors (my apologies for the lengthiness):
2015-06-21 01:50:37,318 |OFBiz-batch-3 |GenericDelegator
|I| Delegator "default" initializing helper "trafodion" for entity group "org.ofbiz".
2015-06-21 01:50:37,318 |OFBiz-batch-1 |GenericDelegator
|I| Delegator "default" initializing helper "trafodiontenant" for entity group "org.ofbiz.tenant".
2015-06-21 01:50:37,318 |OFBiz-batch-2 |GenericDelegator
|I| Delegator "default" initializing helper "trafodionolap" for entity group "org.ofbiz.olap".
2015-06-21 01:50:37,324 |OFBiz-batch-3 |GenericDelegator
|I| Doing database check as requested in entityengine.xml with addMissing=true
2015-06-21 01:50:37,324 |OFBiz-batch-1 |GenericDelegator
|I| Doing database check as requested in entityengine.xml with addMissing=true
2015-06-21 01:50:37,324 |OFBiz-batch-2 |GenericDelegator
|I| Doing database check as requested in entityengine.xml with addMissing=true
2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
|E| Unable to establish a connection with the database for helperName [trafodion]... Error was: java.sql.SQLException: Unable to acquire a new connection from the pool
2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
|E| Unable to establish a connection with the database, no additional information available.
2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
|E| Could not get table name information from the database, aborting.
2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
|I| Database Product Name is Trafodion
2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
|I| Database Product Version is 1.1
2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
|I| Database Driver Name is org.trafodion.jdbc.t4.T4Driver
2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
|I| Database Driver Version is Traf_JDBC_Type4_Build_17dd8d9
2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
|I| Database Driver JDBC Version is 3.1
2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
|I| Database Setting/Support Information (those with a * should be true):
2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
|I| - supports transactions [true]*
2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
|I| - isolation None [true]
2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
|I| - isolation ReadCommitted [true]
2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
|I| - isolation ReadUncommitted [true]
2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
|I| - isolation RepeatableRead [true]
2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
|I| - isolation Serializable [true]
2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
|I| - forward only type [true]
2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
|I| - scroll sensitive type [false]
2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
|I| - scroll insensitive type [true]
2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
|I| - is case sensitive [false]
2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
|I| - stores LowerCase [false]
2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
|I| - stores MixedCase [false]
2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
|I| - stores UpperCase [true]
2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
|I| - max table name length [128]
2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
|I| - max column name length [128]
2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
|I| - concurrent connections [0]
2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
|I| - concurrent statements [0]
2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
|I| - ANSI SQL92 Entry [true]
2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
|I| - ANSI SQL92 Intermediate [false]
2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
|I| - ANSI SQL92 Full [false]
2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
|I| - ODBC SQL Grammar Core [true]
2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
|I| - ODBC SQL Grammar Extended [false]
2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
|I| - ODBC SQL Grammar Minimum [true]
2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
|I| - outer joins [true]*
2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
|I| - limited outer joins [true]
2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
|I| - full outer joins [false]
2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
|I| - group by [true]*
2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
|I| - group by not in select [false]
2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
|I| - column aliasing [true]
2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
|I| - order by not in select [true]
2015-06-21 01:50:42,811 |OFBiz-batch-2 |DatabaseUtil
|I| - alter table add column [false]*
2015-06-21 01:50:42,811 |OFBiz-batch-2 |DatabaseUtil
|I| - non-nullable column [true]*
2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
|I| - default fetchsize [100]
2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
|I| - named parameters [ SKIPPED ]
2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
|I| Getting Table Info From Database
2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
|I| Database Product Name is Trafodion
2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
|I| Database Product Version is 1.1
2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
|I| Database Driver Name is org.trafodion.jdbc.t4.T4Driver
2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
|I| Database Driver Version is Traf_JDBC_Type4_Build_17dd8d9
2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
|I| Database Driver JDBC Version is 3.1
2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
|I| Database Setting/Support Information (those with a * should be true):
2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
|I| - supports transactions [true]*
2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
|I| - isolation None [true]
2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
|I| - isolation ReadCommitted [true]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - isolation ReadUncommitted [true]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - isolation RepeatableRead [true]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - isolation Serializable [true]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - forward only type [true]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - scroll sensitive type [false]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - scroll insensitive type [true]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - is case sensitive [false]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - stores LowerCase [false]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - stores MixedCase [false]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - stores UpperCase [true]
2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
|I| - max table name length [128]
2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
|I| - max column name length [128]
2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
|I| - concurrent connections [0]
2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
|I| - concurrent statements [0]
2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
|I| - ANSI SQL92 Entry [true]
2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
|I| - ANSI SQL92 Intermediate [false]
2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
|I| - ANSI SQL92 Full [false]
2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
|I| - ODBC SQL Grammar Core [true]
2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
|I| - ODBC SQL Grammar Extended [false]
2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
|I| - ODBC SQL Grammar Minimum [true]
2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
|I| - outer joins [true]*
2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
|I| - limited outer joins [true]
2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
|I| - full outer joins [false]
2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
|I| - group by [true]*
2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
|I| - group by not in select [false]
2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
|I| - column aliasing [true]
2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
|I| - order by not in select [true]
2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
|I| - alter table add column [false]*
2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
|I| - non-nullable column [true]*
2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
|I| - default fetchsize [100]
2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
|I| - named parameters [ SKIPPED ]
2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
|I| Getting Table Info From Database
2015-06-21 01:50:44,692 |OFBiz-batch-2 |DatabaseUtil
|W| Entity [CurrencyDimension] has no table in the database
2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
|W| Entity [DateDimension] has no table in the database
2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
|W| Entity [InventoryItemFact] has no table in the database
2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
|W| Entity [ProductDimension] has no table in the database
2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
|W| Entity [SalesInvoiceItemFact] has no table in the database
2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
|W| Entity [SalesOrderItemFact] has no table in the database
2015-06-21 01:50:44,722 |pool-2-thread-1 |DatabaseUtil
|E| Unable to establish a connection with the database for helperName [trafodionolap]... Error was: java.sql.SQLException: Unable to acquire a new connection from the pool
java.sql.SQLException: Unable to acquire a new connection from the pool at
org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:130)
~[commons-dbcp2-2.1.jar:2.1]
at
org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:60)
~[commons-dbcp2-2.1.jar:2.1]
at
org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:82)
~[commons-dbcp2-2.1.jar:2.1]
at
org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:63)
~[ofbiz-entity.jar:?]
at
org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:83)
~[ofbiz-geronimo.jar:?]
at org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:96)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.jdbc.DatabaseUtil.createTable(DatabaseUtil.java:1591)
[ofbiz-entity.jar:?]
at
org.ofbiz.entity.jdbc.DatabaseUtil$CreateTableCallable.call(DatabaseUtil.java:1529)
[ofbiz-entity.jar:?]
at
org.ofbiz.entity.jdbc.DatabaseUtil$CreateTableCallable.call(DatabaseUtil.java:1515)
[ofbiz-entity.jar:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_45] at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[?:1.8.0_45]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[?:1.8.0_45]
at java.lang.Thread.run(Thread.java:745) [?:1.8.0_45] Caused by: org.trafodion.jdbc.t4.HPT4Exception: The message id:
as_connect_message_error With parameters: server handle not available at
org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.java:304)
~[jdbcT4.jar:?]
at
org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.java:238)
~[jdbcT4.jar:?]
at
org.trafodion.jdbc.t4.InterfaceConnection.connect(InterfaceConnection.java:876)
~[jdbcT4.jar:?]
at
org.trafodion.jdbc.t4.InterfaceConnection.<init>(InterfaceConnection.java:173)
~[jdbcT4.jar:?]
at
org.trafodion.jdbc.t4.TrafT4Connection.makeConnection(TrafT4Connection.java:1608)
~[jdbcT4.jar:?]
at
org.trafodion.jdbc.t4.TrafT4Connection.<init>(TrafT4Connection.java:1561)
~[jdbcT4.jar:?]
at
org.trafodion.jdbc.t4.HPT4DataSource.getConnection(HPT4DataSource.java:129)
~[jdbcT4.jar:?]
at
org.trafodion.jdbc.t4.HPT4DataSource.getConnection(HPT4DataSource.java:173)
~[jdbcT4.jar:?]
at org.trafodion.jdbc.t4.T4Driver.connect(T4Driver.java:183) ~[jdbcT4.jar:?]
And more...
Do you perhaps have any ideas on how to resolve this?
Best regards,
Pierre Smits
*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com
Re: Manual installation of Trafodion
Posted by Pierre Smits <pi...@gmail.com>.
Hi Suresh,
Thanks for the quick response.
So I defined the connection as follows (for the connection to the ofbiz
namespace as follows:
<datasource name="trafodion"
> add-missing-on-start="true"
> alias-view-columns="false"
> check-on-start="true"
> field-type-name="trafodion"
> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> join-style="ansi"
> result-fetch-size="50"
> schema-name="ofbiz"
> use-binary-type-for-blob="true"
> use-fk-initially-deferred="false"
> use-order-by-nulls="true"
> >
> <read-data reader-name="seed"/>
> <read-data reader-name="seed-initial"/>
> <read-data reader-name="ext"/>
> <read-data reader-name="demo"/>
> <inline-jdbc
> jdbc-driver="org.trafodion.jdbc.t4.T4Driver"
> jdbc-uri="jdbc:t4jdbc://10.0.1.38:37800/ofbiz"
> jdbc-username="ofbiz"
> jdbc-password="ofbiz"
> isolation-level="ReadCommitted"
> pool-minsize="2"
> pool-maxsize="250"
> time-between-eviction-runs-millis="600000"/>
> </datasource>
Which is the common way to define the connection in OFBiz, and fired up.
And I got following errors (my apologies for the lengthiness):
2015-06-21 01:50:37,318 |OFBiz-batch-3 |GenericDelegator
|I| Delegator "default" initializing helper "trafodion" for entity group
"org.ofbiz".
2015-06-21 01:50:37,318 |OFBiz-batch-1 |GenericDelegator
|I| Delegator "default" initializing helper "trafodiontenant" for entity
group "org.ofbiz.tenant".
2015-06-21 01:50:37,318 |OFBiz-batch-2 |GenericDelegator
|I| Delegator "default" initializing helper "trafodionolap" for entity
group "org.ofbiz.olap".
2015-06-21 01:50:37,324 |OFBiz-batch-3 |GenericDelegator
|I| Doing database check as requested in entityengine.xml with
addMissing=true
2015-06-21 01:50:37,324 |OFBiz-batch-1 |GenericDelegator
|I| Doing database check as requested in entityengine.xml with
addMissing=true
2015-06-21 01:50:37,324 |OFBiz-batch-2 |GenericDelegator
|I| Doing database check as requested in entityengine.xml with
addMissing=true
2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
|E| Unable to establish a connection with the database for helperName
[trafodion]... Error was: java.sql.SQLException: Unable to acquire a new
connection from the pool
2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
|E| Unable to establish a connection with the database, no additional
information available.
2015-06-21 01:50:38,639 |OFBiz-batch-3 |DatabaseUtil
|E| Could not get table name information from the database, aborting.
2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
|I| Database Product Name is Trafodion
2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
|I| Database Product Version is 1.1
2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
|I| Database Driver Name is org.trafodion.jdbc.t4.T4Driver
2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
|I| Database Driver Version is Traf_JDBC_Type4_Build_17dd8d9
2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
|I| Database Driver JDBC Version is 3.1
2015-06-21 01:50:42,806 |OFBiz-batch-2 |DatabaseUtil
|I| Database Setting/Support Information (those with a * should be true):
2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
|I| - supports transactions [true]*
2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
|I| - isolation None [true]
2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
|I| - isolation ReadCommitted [true]
2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
|I| - isolation ReadUncommitted [true]
2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
|I| - isolation RepeatableRead [true]
2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
|I| - isolation Serializable [true]
2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
|I| - forward only type [true]
2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
|I| - scroll sensitive type [false]
2015-06-21 01:50:42,807 |OFBiz-batch-2 |DatabaseUtil
|I| - scroll insensitive type [true]
2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
|I| - is case sensitive [false]
2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
|I| - stores LowerCase [false]
2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
|I| - stores MixedCase [false]
2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
|I| - stores UpperCase [true]
2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
|I| - max table name length [128]
2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
|I| - max column name length [128]
2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
|I| - concurrent connections [0]
2015-06-21 01:50:42,808 |OFBiz-batch-2 |DatabaseUtil
|I| - concurrent statements [0]
2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
|I| - ANSI SQL92 Entry [true]
2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
|I| - ANSI SQL92 Intermediate [false]
2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
|I| - ANSI SQL92 Full [false]
2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
|I| - ODBC SQL Grammar Core [true]
2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
|I| - ODBC SQL Grammar Extended [false]
2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
|I| - ODBC SQL Grammar Minimum [true]
2015-06-21 01:50:42,809 |OFBiz-batch-2 |DatabaseUtil
|I| - outer joins [true]*
2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
|I| - limited outer joins [true]
2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
|I| - full outer joins [false]
2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
|I| - group by [true]*
2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
|I| - group by not in select [false]
2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
|I| - column aliasing [true]
2015-06-21 01:50:42,810 |OFBiz-batch-2 |DatabaseUtil
|I| - order by not in select [true]
2015-06-21 01:50:42,811 |OFBiz-batch-2 |DatabaseUtil
|I| - alter table add column [false]*
2015-06-21 01:50:42,811 |OFBiz-batch-2 |DatabaseUtil
|I| - non-nullable column [true]*
2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
|I| - default fetchsize [100]
2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
|I| - named parameters [ SKIPPED ]
2015-06-21 01:50:42,926 |OFBiz-batch-2 |DatabaseUtil
|I| Getting Table Info From Database
2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
|I| Database Product Name is Trafodion
2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
|I| Database Product Version is 1.1
2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
|I| Database Driver Name is org.trafodion.jdbc.t4.T4Driver
2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
|I| Database Driver Version is Traf_JDBC_Type4_Build_17dd8d9
2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
|I| Database Driver JDBC Version is 3.1
2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
|I| Database Setting/Support Information (those with a * should be true):
2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
|I| - supports transactions [true]*
2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
|I| - isolation None [true]
2015-06-21 01:50:44,371 |OFBiz-batch-1 |DatabaseUtil
|I| - isolation ReadCommitted [true]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - isolation ReadUncommitted [true]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - isolation RepeatableRead [true]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - isolation Serializable [true]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - forward only type [true]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - scroll sensitive type [false]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - scroll insensitive type [true]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - is case sensitive [false]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - stores LowerCase [false]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - stores MixedCase [false]
2015-06-21 01:50:44,372 |OFBiz-batch-1 |DatabaseUtil
|I| - stores UpperCase [true]
2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
|I| - max table name length [128]
2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
|I| - max column name length [128]
2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
|I| - concurrent connections [0]
2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
|I| - concurrent statements [0]
2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
|I| - ANSI SQL92 Entry [true]
2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
|I| - ANSI SQL92 Intermediate [false]
2015-06-21 01:50:44,373 |OFBiz-batch-1 |DatabaseUtil
|I| - ANSI SQL92 Full [false]
2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
|I| - ODBC SQL Grammar Core [true]
2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
|I| - ODBC SQL Grammar Extended [false]
2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
|I| - ODBC SQL Grammar Minimum [true]
2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
|I| - outer joins [true]*
2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
|I| - limited outer joins [true]
2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
|I| - full outer joins [false]
2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
|I| - group by [true]*
2015-06-21 01:50:44,374 |OFBiz-batch-1 |DatabaseUtil
|I| - group by not in select [false]
2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
|I| - column aliasing [true]
2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
|I| - order by not in select [true]
2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
|I| - alter table add column [false]*
2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
|I| - non-nullable column [true]*
2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
|I| - default fetchsize [100]
2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
|I| - named parameters [ SKIPPED ]
2015-06-21 01:50:44,375 |OFBiz-batch-1 |DatabaseUtil
|I| Getting Table Info From Database
2015-06-21 01:50:44,692 |OFBiz-batch-2 |DatabaseUtil
|W| Entity [CurrencyDimension] has no table in the database
2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
|W| Entity [DateDimension] has no table in the database
2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
|W| Entity [InventoryItemFact] has no table in the database
2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
|W| Entity [ProductDimension] has no table in the database
2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
|W| Entity [SalesInvoiceItemFact] has no table in the database
2015-06-21 01:50:44,693 |OFBiz-batch-2 |DatabaseUtil
|W| Entity [SalesOrderItemFact] has no table in the database
2015-06-21 01:50:44,722 |pool-2-thread-1 |DatabaseUtil
|E| Unable to establish a connection with the database for helperName
[trafodionolap]... Error was: java.sql.SQLException: Unable to acquire a
new connection from the pool
java.sql.SQLException: Unable to acquire a new connection from the pool
at
org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:130)
~[commons-dbcp2-2.1.jar:2.1]
at
org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:60)
~[commons-dbcp2-2.1.jar:2.1]
at
org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:82)
~[commons-dbcp2-2.1.jar:2.1]
at
org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:63)
~[ofbiz-entity.jar:?]
at
org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:83)
~[ofbiz-geronimo.jar:?]
at org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:96)
~[ofbiz-entity.jar:?]
at org.ofbiz.entity.jdbc.DatabaseUtil.createTable(DatabaseUtil.java:1591)
[ofbiz-entity.jar:?]
at
org.ofbiz.entity.jdbc.DatabaseUtil$CreateTableCallable.call(DatabaseUtil.java:1529)
[ofbiz-entity.jar:?]
at
org.ofbiz.entity.jdbc.DatabaseUtil$CreateTableCallable.call(DatabaseUtil.java:1515)
[ofbiz-entity.jar:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_45]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[?:1.8.0_45]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[?:1.8.0_45]
at java.lang.Thread.run(Thread.java:745) [?:1.8.0_45]
Caused by: org.trafodion.jdbc.t4.HPT4Exception: The message id:
as_connect_message_error With parameters: server handle not available
at
org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.java:304)
~[jdbcT4.jar:?]
at
org.trafodion.jdbc.t4.HPT4Messages.createSQLException(HPT4Messages.java:238)
~[jdbcT4.jar:?]
at
org.trafodion.jdbc.t4.InterfaceConnection.connect(InterfaceConnection.java:876)
~[jdbcT4.jar:?]
at
org.trafodion.jdbc.t4.InterfaceConnection.<init>(InterfaceConnection.java:173)
~[jdbcT4.jar:?]
at
org.trafodion.jdbc.t4.TrafT4Connection.makeConnection(TrafT4Connection.java:1608)
~[jdbcT4.jar:?]
at
org.trafodion.jdbc.t4.TrafT4Connection.<init>(TrafT4Connection.java:1561)
~[jdbcT4.jar:?]
at
org.trafodion.jdbc.t4.HPT4DataSource.getConnection(HPT4DataSource.java:129)
~[jdbcT4.jar:?]
at
org.trafodion.jdbc.t4.HPT4DataSource.getConnection(HPT4DataSource.java:173)
~[jdbcT4.jar:?]
at org.trafodion.jdbc.t4.T4Driver.connect(T4Driver.java:183) ~[jdbcT4.jar:?]
And more...
Do you perhaps have any ideas on how to resolve this?
Best regards,
Pierre Smits
*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com
RE: Manual installation of Trafodion
Posted by "Subbiah, Suresh" <Su...@hp.com>.
Hi Pierre,
Both are supported in Trafodion. So either one should work. The application can pick which one is more suitable for the given environment.
Note that a T2 application will be hosted on the cluster and will be running on one of the Trafodion nodes. A T4 application can run on a remote client machine and will connect to the Trafodion cluster through JDBC. In this case the primary Trafodion process executing on behalf of the T4 application will be mxosrvr.
Thanks
Suresh
-----Original Message-----
From: Pierre Smits [mailto:pierre.smits@gmail.com]
Sent: Saturday, June 20, 2015 6:21 PM
To: dev@trafodion.incubator.apache.org
Subject: Re: Manual installation of Trafodion
Should I use the jdbc t2 or the jdbc t4 driver?
Best regards,
Pierre Smits
*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com
On Sat, Jun 20, 2015 at 3:27 PM, Pierre Smits <pi...@gmail.com>
wrote:
> It helps, of course, to put the right driver in place.
>
> To be continued.
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
> On Sat, Jun 20, 2015 at 10:05 AM, Pierre Smits
> <pi...@gmail.com>
> wrote:
>
>> Hi Suresh, All,
>>
>> I went the path as suggested, and startup of sandbox went fine. I
>> configured my OFBiz frontend to point to the Trafodion sandbox,
>> created the namespaces required (ofbiz, ofbizolap and ofbiztenant)
>> and fired up my OFBiz instantiation. And then I got stuck, as a
>> connection error occured, see below.
>>
>> [java] 2015-06-19 09:28:45,390 |OFBiz-batch-3
>>> |DBCPConnectionFactory |E| null
>>> [java] java.lang.ClassNotFoundException:
>>> org.apache.hadoop.hive.jdbc.HiveDriver
>>> [java] at
>>> java.net.URLClassLoader.findClass(URLClassLoader.java:381) ~[?:1.8.0_45]
>>> [java] at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>>> ~[?:1.8.0_45]
>>> [java] at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
>>> ~[?:1.8.0_45]
>>> [java] at java.lang.Class.forName0(Native Method) ~[?:1.8.0_45]
>>> [java] at java.lang.Class.forName(Class.java:348) ~[?:1.8.0_45]
>>> [java] at
>>> org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCP
>>> ConnectionFactory.java:88)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(Geronimo
>>> TransactionFactory.java:83)
>>> [ofbiz-geronimo.jar:?]
>>> [java] at
>>> org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:9
>>> 6)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.jdbc.DatabaseUtil.getConnectionLogged(DatabaseUtil.
>>> java:146)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(DatabaseUtil.java:9
>>> 17)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:183)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:169)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.datasource.GenericDAO.checkDb(GenericDAO.java:1223)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(Generic
>>> HelperDAO.java:195)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.GenericDelegator.initializeOneGenericHelper(Generic
>>> Delegator.java:271)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.GenericDelegator.access$000(GenericDelegator.java:9
>>> 1)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.GenericDelegator$1.call(GenericDelegator.java:283)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.GenericDelegator$1.call(GenericDelegator.java:280)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> java.util.concurrent.FutureTask.run(FutureTask.java:266)
>>> [?:1.8.0_45]
>>> [java] at
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor
>>> .java:1142)
>>> [?:1.8.0_45]
>>> [java] at
>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecuto
>>> r.java:617)
>>> [?:1.8.0_45]
>>> [java] at java.lang.Thread.run(Thread.java:745) [?:1.8.0_45]
>>> [java] 2015-06-19 09:28:45,396 |OFBiz-batch-3 |DatabaseUtil
>>> |E| Unable to establish a connection with the
>>> database for helperName [trafodion]... Error was:
>>> org.ofbiz.entity.GenericEntityException:
>>> org.apache.hadoop.hive.jdbc.HiveDriver
>>> (org.apache.hadoop.hive.jdbc.HiveDriver)
>>> [java] 2015-06-19 09:28:45,396 |OFBiz-batch-3 |DatabaseUtil
>>> |E| Unable to establish a connection with the
>>> database, no additional information available.
>>> [java] 2015-06-19 09:28:45,396 |OFBiz-batch-3 |DatabaseUtil
>>> |E| Could not get table name information from the
>>> database, aborting.
>>> [java] 2015-06-19 09:28:45,397 |OFBiz-batch-1
>>> |DBCPConnectionFactory |E| null
>>
>>
>> Any pointers?
>>
>> Best regards,
>>
>> Pierre Smits
>>
>> *ORRTIZ.COM <http://www.orrtiz.com>*
>> Services & Solutions for Cloud-
>> Based Manufacturing, Professional
>> Services and Retail & Trade
>> http://www.orrtiz.com
>>
>> On Thu, Jun 18, 2015 at 9:58 AM, Pierre Smits
>> <pi...@gmail.com>
>> wrote:
>>
>>> Hi Suresh, All,
>>>
>>> Thanks for the fast follow up. I will explore that path.
>>>
>>> Best regards,
>>>
>>>
>>>
>>> Pierre Smits
>>>
>>> *ORRTIZ.COM <http://www.orrtiz.com>* Services & Solutions for Cloud-
>>> Based Manufacturing, Professional Services and Retail & Trade
>>> http://www.orrtiz.com
>>>
>>> On Wed, Jun 17, 2015 at 5:45 PM, Subbiah, Suresh
>>> <Su...@hp.com>
>>> wrote:
>>>
>>>> Hi Pierre,
>>>>
>>>> Here is a response from Chris and Amanda. They may not be on this
>>>> mailing list yet, so I am forwarding their response
>>>>
>>>> "We don't have a trafodion build that runs in a Mac OS X environment.
>>>>
>>>> My only suggestion for running on a Mac would be to install
>>>> VirtualBox on the Mac and install our Sandbox.
>>>>
>>>> Download Oracle VirtualBox 5.0 Release Candidate 1 (RC1) for Linux,
>>>> Mac OS X, and Microsoft Windows
>>>> http://linux.softpedia.com/get/System/Emulators/Oracle-VM-VirtualBo
>>>> x-23194.shtml
>>>> "
>>>>
>>>> Thanks
>>>> Suresh
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: Pierre Smits [mailto:pierre.smits@gmail.com]
>>>> Sent: Wednesday, June 17, 2015 1:40 AM
>>>> To: dev@trafodion.incubator.apache.org
>>>> Subject: Manual installation of Trafodion
>>>>
>>>> Hi All,
>>>>
>>>> I am trying to execute a PoC whereby applying Trafodion as the
>>>> persistence layer for an Apache OFBiz setup. Unfortunately, I have
>>>> to execute this PoC on a Mac. I have looked at both the CDH and
>>>> the HDP to see if there were installers available for Apple, but
>>>> both provided no easy means to install those... So everything needs to be installed manually.
>>>>
>>>> As I was browsing through the pages of trafodion.org I only found
>>>> pages related to applying the installer to implement Trafodion on
>>>> top of either HDP or HDP. So I am looking for some guidance
>>>> (pointers, tips and tricks).
>>>> Thus far I have Hadoop (r2.7.0), HBase (r1.0.1) and Hive (r1.1.1)
>>>> up and running on the Mac. What else do I need to look at?
>>>>
>>>> Best regards,
>>>>
>>>> Pierre Smits
>>>>
>>>> *ORRTIZ.COM <http://www.orrtiz.com>* Services & Solutions for
>>>> Cloud- Based Manufacturing, Professional Services and Retail &
>>>> Trade http://www.orrtiz.com
>>>>
>>>
>>>
>>
>
Re: Manual installation of Trafodion
Posted by Pierre Smits <pi...@gmail.com>.
Should I use the jdbc t2 or the jdbc t4 driver?
Best regards,
Pierre Smits
*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com
On Sat, Jun 20, 2015 at 3:27 PM, Pierre Smits <pi...@gmail.com>
wrote:
> It helps, of course, to put the right driver in place.
>
> To be continued.
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
> On Sat, Jun 20, 2015 at 10:05 AM, Pierre Smits <pi...@gmail.com>
> wrote:
>
>> Hi Suresh, All,
>>
>> I went the path as suggested, and startup of sandbox went fine. I
>> configured my OFBiz frontend to point to the Trafodion sandbox, created the
>> namespaces required (ofbiz, ofbizolap and ofbiztenant) and fired up my
>> OFBiz instantiation. And then I got stuck, as a connection error occured,
>> see below.
>>
>> [java] 2015-06-19 09:28:45,390 |OFBiz-batch-3
>>> |DBCPConnectionFactory |E| null
>>> [java] java.lang.ClassNotFoundException:
>>> org.apache.hadoop.hive.jdbc.HiveDriver
>>> [java] at
>>> java.net.URLClassLoader.findClass(URLClassLoader.java:381) ~[?:1.8.0_45]
>>> [java] at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>>> ~[?:1.8.0_45]
>>> [java] at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
>>> ~[?:1.8.0_45]
>>> [java] at java.lang.Class.forName0(Native Method) ~[?:1.8.0_45]
>>> [java] at java.lang.Class.forName(Class.java:348) ~[?:1.8.0_45]
>>> [java] at
>>> org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:88)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:83)
>>> [ofbiz-geronimo.jar:?]
>>> [java] at
>>> org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:96)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.jdbc.DatabaseUtil.getConnectionLogged(DatabaseUtil.java:146)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(DatabaseUtil.java:917)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:183)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:169)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.datasource.GenericDAO.checkDb(GenericDAO.java:1223)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(GenericHelperDAO.java:195)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.GenericDelegator.initializeOneGenericHelper(GenericDelegator.java:271)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.GenericDelegator.access$000(GenericDelegator.java:91)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.GenericDelegator$1.call(GenericDelegator.java:283)
>>> [ofbiz-entity.jar:?]
>>> [java] at
>>> org.ofbiz.entity.GenericDelegator$1.call(GenericDelegator.java:280)
>>> [ofbiz-entity.jar:?]
>>> [java] at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>>> [?:1.8.0_45]
>>> [java] at
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>> [?:1.8.0_45]
>>> [java] at
>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>> [?:1.8.0_45]
>>> [java] at java.lang.Thread.run(Thread.java:745) [?:1.8.0_45]
>>> [java] 2015-06-19 09:28:45,396 |OFBiz-batch-3 |DatabaseUtil
>>> |E| Unable to establish a connection with the database for
>>> helperName [trafodion]... Error was:
>>> org.ofbiz.entity.GenericEntityException:
>>> org.apache.hadoop.hive.jdbc.HiveDriver
>>> (org.apache.hadoop.hive.jdbc.HiveDriver)
>>> [java] 2015-06-19 09:28:45,396 |OFBiz-batch-3 |DatabaseUtil
>>> |E| Unable to establish a connection with the database, no
>>> additional information available.
>>> [java] 2015-06-19 09:28:45,396 |OFBiz-batch-3 |DatabaseUtil
>>> |E| Could not get table name information from the
>>> database, aborting.
>>> [java] 2015-06-19 09:28:45,397 |OFBiz-batch-1
>>> |DBCPConnectionFactory |E| null
>>
>>
>> Any pointers?
>>
>> Best regards,
>>
>> Pierre Smits
>>
>> *ORRTIZ.COM <http://www.orrtiz.com>*
>> Services & Solutions for Cloud-
>> Based Manufacturing, Professional
>> Services and Retail & Trade
>> http://www.orrtiz.com
>>
>> On Thu, Jun 18, 2015 at 9:58 AM, Pierre Smits <pi...@gmail.com>
>> wrote:
>>
>>> Hi Suresh, All,
>>>
>>> Thanks for the fast follow up. I will explore that path.
>>>
>>> Best regards,
>>>
>>>
>>>
>>> Pierre Smits
>>>
>>> *ORRTIZ.COM <http://www.orrtiz.com>*
>>> Services & Solutions for Cloud-
>>> Based Manufacturing, Professional
>>> Services and Retail & Trade
>>> http://www.orrtiz.com
>>>
>>> On Wed, Jun 17, 2015 at 5:45 PM, Subbiah, Suresh <Su...@hp.com>
>>> wrote:
>>>
>>>> Hi Pierre,
>>>>
>>>> Here is a response from Chris and Amanda. They may not be on this
>>>> mailing list yet, so I am forwarding their response
>>>>
>>>> "We don't have a trafodion build that runs in a Mac OS X environment.
>>>>
>>>> My only suggestion for running on a Mac would be to install VirtualBox
>>>> on the Mac and install our Sandbox.
>>>>
>>>> Download Oracle VirtualBox 5.0 Release Candidate 1 (RC1) for Linux, Mac
>>>> OS X, and Microsoft Windows
>>>> http://linux.softpedia.com/get/System/Emulators/Oracle-VM-VirtualBox-23194.shtml
>>>> "
>>>>
>>>> Thanks
>>>> Suresh
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: Pierre Smits [mailto:pierre.smits@gmail.com]
>>>> Sent: Wednesday, June 17, 2015 1:40 AM
>>>> To: dev@trafodion.incubator.apache.org
>>>> Subject: Manual installation of Trafodion
>>>>
>>>> Hi All,
>>>>
>>>> I am trying to execute a PoC whereby applying Trafodion as the
>>>> persistence layer for an Apache OFBiz setup. Unfortunately, I have to
>>>> execute this PoC on a Mac. I have looked at both the CDH and the HDP to
>>>> see if there were installers available for Apple, but both provided no easy
>>>> means to install those... So everything needs to be installed manually.
>>>>
>>>> As I was browsing through the pages of trafodion.org I only found
>>>> pages related to applying the installer to implement Trafodion on top of
>>>> either HDP or HDP. So I am looking for some guidance (pointers, tips and
>>>> tricks).
>>>> Thus far I have Hadoop (r2.7.0), HBase (r1.0.1) and Hive (r1.1.1) up
>>>> and running on the Mac. What else do I need to look at?
>>>>
>>>> Best regards,
>>>>
>>>> Pierre Smits
>>>>
>>>> *ORRTIZ.COM <http://www.orrtiz.com>*
>>>> Services & Solutions for Cloud-
>>>> Based Manufacturing, Professional
>>>> Services and Retail & Trade
>>>> http://www.orrtiz.com
>>>>
>>>
>>>
>>
>
Re: Manual installation of Trafodion
Posted by Pierre Smits <pi...@gmail.com>.
It helps, of course, to put the right driver in place.
To be continued.
Pierre Smits
*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com
On Sat, Jun 20, 2015 at 10:05 AM, Pierre Smits <pi...@gmail.com>
wrote:
> Hi Suresh, All,
>
> I went the path as suggested, and startup of sandbox went fine. I
> configured my OFBiz frontend to point to the Trafodion sandbox, created the
> namespaces required (ofbiz, ofbizolap and ofbiztenant) and fired up my
> OFBiz instantiation. And then I got stuck, as a connection error occured,
> see below.
>
> [java] 2015-06-19 09:28:45,390 |OFBiz-batch-3
>> |DBCPConnectionFactory |E| null
>> [java] java.lang.ClassNotFoundException:
>> org.apache.hadoop.hive.jdbc.HiveDriver
>> [java] at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
>> ~[?:1.8.0_45]
>> [java] at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>> ~[?:1.8.0_45]
>> [java] at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
>> ~[?:1.8.0_45]
>> [java] at java.lang.Class.forName0(Native Method) ~[?:1.8.0_45]
>> [java] at java.lang.Class.forName(Class.java:348) ~[?:1.8.0_45]
>> [java] at
>> org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:88)
>> [ofbiz-entity.jar:?]
>> [java] at
>> org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:83)
>> [ofbiz-geronimo.jar:?]
>> [java] at
>> org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:96)
>> [ofbiz-entity.jar:?]
>> [java] at
>> org.ofbiz.entity.jdbc.DatabaseUtil.getConnectionLogged(DatabaseUtil.java:146)
>> [ofbiz-entity.jar:?]
>> [java] at
>> org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(DatabaseUtil.java:917)
>> [ofbiz-entity.jar:?]
>> [java] at
>> org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:183)
>> [ofbiz-entity.jar:?]
>> [java] at
>> org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:169)
>> [ofbiz-entity.jar:?]
>> [java] at
>> org.ofbiz.entity.datasource.GenericDAO.checkDb(GenericDAO.java:1223)
>> [ofbiz-entity.jar:?]
>> [java] at
>> org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(GenericHelperDAO.java:195)
>> [ofbiz-entity.jar:?]
>> [java] at
>> org.ofbiz.entity.GenericDelegator.initializeOneGenericHelper(GenericDelegator.java:271)
>> [ofbiz-entity.jar:?]
>> [java] at
>> org.ofbiz.entity.GenericDelegator.access$000(GenericDelegator.java:91)
>> [ofbiz-entity.jar:?]
>> [java] at
>> org.ofbiz.entity.GenericDelegator$1.call(GenericDelegator.java:283)
>> [ofbiz-entity.jar:?]
>> [java] at
>> org.ofbiz.entity.GenericDelegator$1.call(GenericDelegator.java:280)
>> [ofbiz-entity.jar:?]
>> [java] at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>> [?:1.8.0_45]
>> [java] at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>> [?:1.8.0_45]
>> [java] at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>> [?:1.8.0_45]
>> [java] at java.lang.Thread.run(Thread.java:745) [?:1.8.0_45]
>> [java] 2015-06-19 09:28:45,396 |OFBiz-batch-3 |DatabaseUtil
>> |E| Unable to establish a connection with the database for
>> helperName [trafodion]... Error was:
>> org.ofbiz.entity.GenericEntityException:
>> org.apache.hadoop.hive.jdbc.HiveDriver
>> (org.apache.hadoop.hive.jdbc.HiveDriver)
>> [java] 2015-06-19 09:28:45,396 |OFBiz-batch-3 |DatabaseUtil
>> |E| Unable to establish a connection with the database, no
>> additional information available.
>> [java] 2015-06-19 09:28:45,396 |OFBiz-batch-3 |DatabaseUtil
>> |E| Could not get table name information from the database,
>> aborting.
>> [java] 2015-06-19 09:28:45,397 |OFBiz-batch-1
>> |DBCPConnectionFactory |E| null
>
>
> Any pointers?
>
> Best regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
> On Thu, Jun 18, 2015 at 9:58 AM, Pierre Smits <pi...@gmail.com>
> wrote:
>
>> Hi Suresh, All,
>>
>> Thanks for the fast follow up. I will explore that path.
>>
>> Best regards,
>>
>>
>>
>> Pierre Smits
>>
>> *ORRTIZ.COM <http://www.orrtiz.com>*
>> Services & Solutions for Cloud-
>> Based Manufacturing, Professional
>> Services and Retail & Trade
>> http://www.orrtiz.com
>>
>> On Wed, Jun 17, 2015 at 5:45 PM, Subbiah, Suresh <Su...@hp.com>
>> wrote:
>>
>>> Hi Pierre,
>>>
>>> Here is a response from Chris and Amanda. They may not be on this
>>> mailing list yet, so I am forwarding their response
>>>
>>> "We don't have a trafodion build that runs in a Mac OS X environment.
>>>
>>> My only suggestion for running on a Mac would be to install VirtualBox
>>> on the Mac and install our Sandbox.
>>>
>>> Download Oracle VirtualBox 5.0 Release Candidate 1 (RC1) for Linux, Mac
>>> OS X, and Microsoft Windows
>>> http://linux.softpedia.com/get/System/Emulators/Oracle-VM-VirtualBox-23194.shtml
>>> "
>>>
>>> Thanks
>>> Suresh
>>>
>>>
>>> -----Original Message-----
>>> From: Pierre Smits [mailto:pierre.smits@gmail.com]
>>> Sent: Wednesday, June 17, 2015 1:40 AM
>>> To: dev@trafodion.incubator.apache.org
>>> Subject: Manual installation of Trafodion
>>>
>>> Hi All,
>>>
>>> I am trying to execute a PoC whereby applying Trafodion as the
>>> persistence layer for an Apache OFBiz setup. Unfortunately, I have to
>>> execute this PoC on a Mac. I have looked at both the CDH and the HDP to
>>> see if there were installers available for Apple, but both provided no easy
>>> means to install those... So everything needs to be installed manually.
>>>
>>> As I was browsing through the pages of trafodion.org I only found pages
>>> related to applying the installer to implement Trafodion on top of either
>>> HDP or HDP. So I am looking for some guidance (pointers, tips and tricks).
>>> Thus far I have Hadoop (r2.7.0), HBase (r1.0.1) and Hive (r1.1.1) up and
>>> running on the Mac. What else do I need to look at?
>>>
>>> Best regards,
>>>
>>> Pierre Smits
>>>
>>> *ORRTIZ.COM <http://www.orrtiz.com>*
>>> Services & Solutions for Cloud-
>>> Based Manufacturing, Professional
>>> Services and Retail & Trade
>>> http://www.orrtiz.com
>>>
>>
>>
>
Re: Manual installation of Trafodion
Posted by Pierre Smits <pi...@gmail.com>.
Hi Suresh, All,
I went the path as suggested, and startup of sandbox went fine. I
configured my OFBiz frontend to point to the Trafodion sandbox, created the
namespaces required (ofbiz, ofbizolap and ofbiztenant) and fired up my
OFBiz instantiation. And then I got stuck, as a connection error occured,
see below.
[java] 2015-06-19 09:28:45,390 |OFBiz-batch-3
> |DBCPConnectionFactory |E| null
> [java] java.lang.ClassNotFoundException:
> org.apache.hadoop.hive.jdbc.HiveDriver
> [java] at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
> ~[?:1.8.0_45]
> [java] at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
> ~[?:1.8.0_45]
> [java] at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
> ~[?:1.8.0_45]
> [java] at java.lang.Class.forName0(Native Method) ~[?:1.8.0_45]
> [java] at java.lang.Class.forName(Class.java:348) ~[?:1.8.0_45]
> [java] at
> org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:88)
> [ofbiz-entity.jar:?]
> [java] at
> org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:83)
> [ofbiz-geronimo.jar:?]
> [java] at
> org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:96)
> [ofbiz-entity.jar:?]
> [java] at
> org.ofbiz.entity.jdbc.DatabaseUtil.getConnectionLogged(DatabaseUtil.java:146)
> [ofbiz-entity.jar:?]
> [java] at
> org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(DatabaseUtil.java:917)
> [ofbiz-entity.jar:?]
> [java] at
> org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:183)
> [ofbiz-entity.jar:?]
> [java] at
> org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:169)
> [ofbiz-entity.jar:?]
> [java] at
> org.ofbiz.entity.datasource.GenericDAO.checkDb(GenericDAO.java:1223)
> [ofbiz-entity.jar:?]
> [java] at
> org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(GenericHelperDAO.java:195)
> [ofbiz-entity.jar:?]
> [java] at
> org.ofbiz.entity.GenericDelegator.initializeOneGenericHelper(GenericDelegator.java:271)
> [ofbiz-entity.jar:?]
> [java] at
> org.ofbiz.entity.GenericDelegator.access$000(GenericDelegator.java:91)
> [ofbiz-entity.jar:?]
> [java] at
> org.ofbiz.entity.GenericDelegator$1.call(GenericDelegator.java:283)
> [ofbiz-entity.jar:?]
> [java] at
> org.ofbiz.entity.GenericDelegator$1.call(GenericDelegator.java:280)
> [ofbiz-entity.jar:?]
> [java] at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> [?:1.8.0_45]
> [java] at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> [?:1.8.0_45]
> [java] at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> [?:1.8.0_45]
> [java] at java.lang.Thread.run(Thread.java:745) [?:1.8.0_45]
> [java] 2015-06-19 09:28:45,396 |OFBiz-batch-3 |DatabaseUtil
> |E| Unable to establish a connection with the database for
> helperName [trafodion]... Error was:
> org.ofbiz.entity.GenericEntityException:
> org.apache.hadoop.hive.jdbc.HiveDriver
> (org.apache.hadoop.hive.jdbc.HiveDriver)
> [java] 2015-06-19 09:28:45,396 |OFBiz-batch-3 |DatabaseUtil
> |E| Unable to establish a connection with the database, no
> additional information available.
> [java] 2015-06-19 09:28:45,396 |OFBiz-batch-3 |DatabaseUtil
> |E| Could not get table name information from the database,
> aborting.
> [java] 2015-06-19 09:28:45,397 |OFBiz-batch-1
> |DBCPConnectionFactory |E| null
Any pointers?
Best regards,
Pierre Smits
*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com
On Thu, Jun 18, 2015 at 9:58 AM, Pierre Smits <pi...@gmail.com>
wrote:
> Hi Suresh, All,
>
> Thanks for the fast follow up. I will explore that path.
>
> Best regards,
>
>
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
> On Wed, Jun 17, 2015 at 5:45 PM, Subbiah, Suresh <Su...@hp.com>
> wrote:
>
>> Hi Pierre,
>>
>> Here is a response from Chris and Amanda. They may not be on this mailing
>> list yet, so I am forwarding their response
>>
>> "We don't have a trafodion build that runs in a Mac OS X environment.
>>
>> My only suggestion for running on a Mac would be to install VirtualBox on
>> the Mac and install our Sandbox.
>>
>> Download Oracle VirtualBox 5.0 Release Candidate 1 (RC1) for Linux, Mac
>> OS X, and Microsoft Windows
>> http://linux.softpedia.com/get/System/Emulators/Oracle-VM-VirtualBox-23194.shtml
>> "
>>
>> Thanks
>> Suresh
>>
>>
>> -----Original Message-----
>> From: Pierre Smits [mailto:pierre.smits@gmail.com]
>> Sent: Wednesday, June 17, 2015 1:40 AM
>> To: dev@trafodion.incubator.apache.org
>> Subject: Manual installation of Trafodion
>>
>> Hi All,
>>
>> I am trying to execute a PoC whereby applying Trafodion as the
>> persistence layer for an Apache OFBiz setup. Unfortunately, I have to
>> execute this PoC on a Mac. I have looked at both the CDH and the HDP to
>> see if there were installers available for Apple, but both provided no easy
>> means to install those... So everything needs to be installed manually.
>>
>> As I was browsing through the pages of trafodion.org I only found pages
>> related to applying the installer to implement Trafodion on top of either
>> HDP or HDP. So I am looking for some guidance (pointers, tips and tricks).
>> Thus far I have Hadoop (r2.7.0), HBase (r1.0.1) and Hive (r1.1.1) up and
>> running on the Mac. What else do I need to look at?
>>
>> Best regards,
>>
>> Pierre Smits
>>
>> *ORRTIZ.COM <http://www.orrtiz.com>*
>> Services & Solutions for Cloud-
>> Based Manufacturing, Professional
>> Services and Retail & Trade
>> http://www.orrtiz.com
>>
>
>
Re: Manual installation of Trafodion
Posted by Pierre Smits <pi...@gmail.com>.
Hi Suresh, All,
Thanks for the fast follow up. I will explore that path.
Best regards,
Pierre Smits
*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com
On Wed, Jun 17, 2015 at 5:45 PM, Subbiah, Suresh <Su...@hp.com>
wrote:
> Hi Pierre,
>
> Here is a response from Chris and Amanda. They may not be on this mailing
> list yet, so I am forwarding their response
>
> "We don't have a trafodion build that runs in a Mac OS X environment.
>
> My only suggestion for running on a Mac would be to install VirtualBox on
> the Mac and install our Sandbox.
>
> Download Oracle VirtualBox 5.0 Release Candidate 1 (RC1) for Linux, Mac OS
> X, and Microsoft Windows
> http://linux.softpedia.com/get/System/Emulators/Oracle-VM-VirtualBox-23194.shtml
> "
>
> Thanks
> Suresh
>
>
> -----Original Message-----
> From: Pierre Smits [mailto:pierre.smits@gmail.com]
> Sent: Wednesday, June 17, 2015 1:40 AM
> To: dev@trafodion.incubator.apache.org
> Subject: Manual installation of Trafodion
>
> Hi All,
>
> I am trying to execute a PoC whereby applying Trafodion as the persistence
> layer for an Apache OFBiz setup. Unfortunately, I have to execute this PoC
> on a Mac. I have looked at both the CDH and the HDP to see if there were
> installers available for Apple, but both provided no easy means to install
> those... So everything needs to be installed manually.
>
> As I was browsing through the pages of trafodion.org I only found pages
> related to applying the installer to implement Trafodion on top of either
> HDP or HDP. So I am looking for some guidance (pointers, tips and tricks).
> Thus far I have Hadoop (r2.7.0), HBase (r1.0.1) and Hive (r1.1.1) up and
> running on the Mac. What else do I need to look at?
>
> Best regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
RE: Manual installation of Trafodion
Posted by "Subbiah, Suresh" <Su...@hp.com>.
Hi Pierre,
Here is a response from Chris and Amanda. They may not be on this mailing list yet, so I am forwarding their response
"We don't have a trafodion build that runs in a Mac OS X environment.
My only suggestion for running on a Mac would be to install VirtualBox on the Mac and install our Sandbox.
Download Oracle VirtualBox 5.0 Release Candidate 1 (RC1) for Linux, Mac OS X, and Microsoft Windows http://linux.softpedia.com/get/System/Emulators/Oracle-VM-VirtualBox-23194.shtml"
Thanks
Suresh
-----Original Message-----
From: Pierre Smits [mailto:pierre.smits@gmail.com]
Sent: Wednesday, June 17, 2015 1:40 AM
To: dev@trafodion.incubator.apache.org
Subject: Manual installation of Trafodion
Hi All,
I am trying to execute a PoC whereby applying Trafodion as the persistence layer for an Apache OFBiz setup. Unfortunately, I have to execute this PoC on a Mac. I have looked at both the CDH and the HDP to see if there were installers available for Apple, but both provided no easy means to install those... So everything needs to be installed manually.
As I was browsing through the pages of trafodion.org I only found pages related to applying the installer to implement Trafodion on top of either HDP or HDP. So I am looking for some guidance (pointers, tips and tricks).
Thus far I have Hadoop (r2.7.0), HBase (r1.0.1) and Hive (r1.1.1) up and running on the Mac. What else do I need to look at?
Best regards,
Pierre Smits
*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com