RE: Help on "databaseManager,ERROR: <SqlQueryExecute><SqlQueryException>(<Replicated>:Table 'moving.xpdlapplicationpackage' doesn't exist)"

"He Wei" <[email protected]>
Newsgroups gmane.comp.java.enhydra.shark
Message-ID <20050804023036.JTPF1187.morpheus1.pacific.net.sg@weihenb> 
Hi Vlada,

 

Is Shark's database name is always "sharkdb" as defined in shark.conf no
matter what kind of database to use?

Could you please help me with the problem? Thank you very much.

Best Regards,

He Wei

 

  _____  

From: He Wei [mailto:[email protected]] 
Sent: Wednesday, August 03, 2005 6:04 PM
To: [email protected]
Subject: RE: [shark] Help on "databaseManager,ERROR:
<SqlQueryExecute><SqlQueryException>(<Replicated>:Table
'moving.xpdlapplicationpackage' doesn't exist)"

 

Here is the exception error message:

I already configure Shark for two databases through DODs, but my application
looks for my table from shark's hsql database. My application uses MySQL
database.

 Please kindly suggest. Thanks.

 

Tool agent map created, maximum number of mappings is 2147483646

Tool agent map created, maximum number of mappings is 2147483646

New mapping added to tool agent map, tool agent map currently has 1 mappings
!

2005-08-03 14:06:40,587:
Activity[Id=201_201_CrossDocking_CrossDockingPalletProcess_CrossDocking_Wor1
_Act16, ba=null, ActDefId=CrossDocking_Wor1_Act16] - Executing tool
[id=TimeLogging]

java.sql.SQLException: Table not found: PALLET in statement [select pallet.*
from pallet WHERE pallet.name_id = ?]

    at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)

    at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)

    at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)

    at
com.lutris.appserver.server.sql.standard.StandardDBConnection.getNewPrepStat
emet(StandardDBConnection.java:328)

    at
com.lutris.appserver.server.sql.standard.StandardDBConnection._prepareStatem
ent(StandardDBConnection.java:308)

    at
com.lutris.appserver.server.sql.standard.StandardDBConnection.prepareStateme
nt(StandardDBConnection.java:282)

    at
com.lutris.dods.builder.generator.query.QueryBuilder.prepareStatement(QueryB
uilder.java:2301)

    at
com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(QueryBuild
er.java:2439)

    at com.idsc.crossdock.bo.PalletQuery.executeQuery(PalletQuery.java:1713)

    at
com.lutris.appserver.server.sql.standard.StandardDBQuery.query(StandardDBQue
ry.java:118)

    at com.idsc.crossdock.bo.PalletQuery.runQuery(PalletQuery.java:1100)

    at com.idsc.crossdock.bo.PalletQuery.getNextDO(PalletQuery.java:1541)

    at
com.idsc.crossdock.utility.crossDockUtility.getPallet(crossDockUtility.java:
496)

    at com.idsc.crossdock.app.timeLogApp.execute(timeLogApp.java:35)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)

    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)

    at java.lang.reflect.Method.invoke(Method.java:324)

    at
org.enhydra.shark.toolagent.JavaClassToolAgent.invokeApplication(JavaClassTo
olAgent.java:53)

    at
org.enhydra.shark.toolagent.DefaultToolAgent.invokeApplication(DefaultToolAg
ent.java:72)

    at
org.enhydra.shark.ToolAgentManagerImpl$ToolRunner.invokeApplication(ToolAgen
tManagerImpl.java:211)

    at
org.enhydra.shark.ToolAgentManagerImpl$ToolRunner.run(ToolAgentManagerImpl.j
ava:96)

    at
org.enhydra.shark.ToolAgentManagerImpl.executeActivity(ToolAgentManagerImpl.
java:67)

    at org.enhydra.shark.WfActivityImpl.runTool(WfActivityImpl.java:1269)

    at
org.enhydra.shark.WfActivityImpl.startActivity(WfActivityImpl.java:1212)

    at org.enhydra.shark.WfActivityImpl.activate(WfActivityImpl.java:1157)

    at org.enhydra.shark.WfProcessImpl.startActivity(WfProcessImpl.java:816)

    at org.enhydra.shark.WfProcessImpl.run(WfProcessImpl.java:695)

    at org.enhydra.shark.WfProcessImpl.start(WfProcessImpl.java:365)

    at org.enhydra.shark.WfProcessWrapper.start(WfProcessWrapper.java:571)

    at org.enhydra.shark.WfProcessWrapper.start(WfProcessWrapper.java:531)

    at com.idsc.crossdock.app.APP.main(APP.java:82)

 

 

  _____  

From: He Wei [mailto:[email protected]] 
Sent: Wednesday, August 03, 2005 11:12 AM
To: [email protected]
Subject: RE: [shark] Help on "databaseManager,ERROR:
<SqlQueryExecute><SqlQueryException>(<Replicated>:Table
'moving.xpdlapplicationpackage' doesn't exist)"

 

Could anybody help me with the problem? 

Is the DODS in Shark configured to work with multiple databases? 

How to solve confliction in the two DODs used by Shark and my application
when running together? 

Thank you very much!

Best Regards,

He Wei

 

  _____  

From: He Wei [mailto:[email protected]] 
Sent: Friday, July 29, 2005 10:30 AM
To: [email protected]
Subject: RE: [shark] Help on "databaseManager,ERROR:
<SqlQueryExecute><SqlQueryException>(<Replicated>:Table
'moving.xpdlapplicationpackage' doesn't exist)"

 

Hi ALL,

 

Regarding to the problem in my previous email, I found it is probably
because Shark is trying to look for the table (of shark) from the database
of my application.  The Shark is invoked from within my application, and
start a process. During the process execution, the process has a
javaclasstoolagent to invoke an application which will call my application
method. My Application is also using DODS to access its database. The
problem happens when my application start its DODs to access its database.
When my application complete and return to Shark, the Shark continues use my
DODs to access shark's database, the error will then occurs. Could you
please help me to solve the problem?

Thanks.

Best Regards,

He Wei

 

  _____  

From: He Wei [mailto:[email protected]] 
Sent: Tuesday, July 26, 2005 10:28 AM
To: [email protected]
Subject: [shark] Help on "databaseManager,ERROR:
<SqlQueryExecute><SqlQueryException>(<Replicated>:Table
'moving.xpdlapplicationpackage' doesn't exist)"

 

Hello,

 

Could anybody please explain me what causes the error below (highlighted in
bold red)? Thank you.

He Wei

 

2005-07-25 16:25:23,765:
Process[key=1_Moving_MovingPalletProcess,mgrname=Moving#1#MovingPalletProces
s] - Activity[Id=1_1_Moving_MovingPalletProcess_Moving_Wor1_Act16, ba=null,
ActDefId=Moving_Wor1_Act16] is completed.

2005-07-25 16:25:23,765:
Process[key=1_Moving_MovingPalletProcess,mgrname=Moving#1#MovingPalletProces
s] - Activity[Id=2_1_Moving_MovingPalletProcess_unloading, ba=null,
ActDefId=unloading] is created

2005-07-25 16:25:23,765:
Activity[Id=2_1_Moving_MovingPalletProcess_unloading, ba=null,
ActDefId=unloading] - Executing tool [id=taskFulfillment]

2005.07.25 16:25:23: databaseManager,ERROR:
<SqlQueryExecute><SqlQueryException>(<Replicated>:Table
'moving.xpdlapplicationpackage' doesn't exist)

2005-07-25 16:25:23,805:
Activity[Id=2_1_Moving_MovingPalletProcess_unloading, ba=null,
ActDefId=unloading] - failed to execute tool [id=taskFulfillment]

2005-07-25 16:25:23,805: Rollback of Shark transaction happened.

com.lutris.dods.builder.generator.query.DataObjectException: Unknown
SQLException: <SqlQueryExecute><SqlQueryException>(<Replicated>:Table
'moving.xpdlapplicationpackage' doesn't exist)

    at
org.enhydra.shark.appmappersistence.data.XPDLApplicationPackageQuery.runQuer
y(XPDLApplicationPackageQuery.java:1033)

    at
org.enhydra.shark.appmappersistence.data.XPDLApplicationPackageQuery.getNext
DO(XPDLApplicationPackageQuery.java:1185)

    at
org.enhydra.shark.appmappersistence.DODSApplicationMappingMgr.getApplication
Map(DODSApplicationMappingMgr.java:711)

    at
org.enhydra.shark.ToolAgentManagerImpl$ToolRunner.invokeApplication(ToolAgen
tManagerImpl.java:170)

    at
org.enhydra.shark.ToolAgentManagerImpl$ToolRunner.run(ToolAgentManagerImpl.j
ava:96)

    at
org.enhydra.shark.ToolAgentManagerImpl.executeActivity(ToolAgentManagerImpl.
java:67)

    at org.enhydra.shark.WfActivityImpl.runTool(WfActivityImpl.java:1269)

    at
org.enhydra.shark.WfActivityImpl.startActivity(WfActivityImpl.java:1212)

    at org.enhydra.shark.WfActivityImpl.activate(WfActivityImpl.java:1157)

    at org.enhydra.shark.WfProcessImpl.startActivity(WfProcessImpl.java:816)

    at org.enhydra.shark.WfProcessImpl.queueNext(WfProcessImpl.java:997)

    at org.enhydra.shark.WfProcessImpl.run(WfProcessImpl.java:703)

    at org.enhydra.shark.WfProcessImpl.start(WfProcessImpl.java:365)

    at org.enhydra.shark.WfProcessWrapper.start(WfProcessWrapper.java:571)

    at org.enhydra.shark.WfProcessWrapper.start(WfProcessWrapper.java:531)

    at com.idsc.moving.app.APP.main(APP.java:82)

Caused by: java.sql.SQLException:
<SqlQueryExecute><SqlQueryException>(<Replicated>:Table
'moving.xpdlapplicationpackage' doesn't exist)

    at
com.lutris.dods.builder.generator.query.QueryBuilder.executeQuery(QueryBuild
er.java:2480)

    at
org.enhydra.shark.appmappersistence.data.XPDLApplicationPackageQuery.execute
Query(XPDLApplicationPackageQuery.java:1357)

    at
com.lutris.appserver.server.sql.standard.StandardDBQuery.query(StandardDBQue
ry.java:118)

    at
org.enhydra.shark.appmappersistence.data.XPDLApplicationPackageQuery.runQuer
y(XPDLApplicationPackageQuery.java:771)

    ... 15 more
message-footer.txt (text/plain, 271 B) 
--
You receive this message as a subscriber of the [email protected] mailing list.
To unsubscribe: mailto:[email protected]
For general help: mailto:[email protected]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.