Win a copy of High Performance Python for Data Analytics this week in the Python forum!

Tom Keaton

Greenhorn
+ Follow
since Feb 24, 2004
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Tom Keaton

give me solution in details,thank in advance
16 years ago
if there is some commands in oracle like bcp in sqlserver can backup data to a file?
16 years ago
I use sql like this:
SELECT type, price, advance

FROM titles

WHERE type LIKE '%cook'

ORDER BY type

COMPUTE SUM(price), SUM(advance) BY type



Here is the result set:

type price advance

------------ -------------------------- --------------------------

mod_cook 19.99 0.00

mod_cook 2.99 15,000.00



sum

==========================

22.98

sum

==========================

15,000.00



type price advance

------------ -------------------------- --------------------------

trad_cook 20.95 7,000.00

trad_cook 11.95 4,000.00

trad_cook 14.99 8,000.00



sum

==========================

47.89

sum

==========================

19,000.00



(7 row(s) affected)



but I only find two records use CDaoRecordset::GetRecordCount
HelloWorld.java

HelloWorldHome.java

HelloWorldBean.java

Lookup.java

it compiled successfully!
then I start tnameserv.exe,it ok!
but when I type:
java Lookup com.sun.jndi.cosnaming.CNCtxFactory iiop://localhost:900 HelloWorldHome
it error:
javax.naming.NameNotFoundException [Root exception is org.omg.CosNaming.NamingCo
ntextPackage.NotFound]
javax.naming.NameNotFoundException. Root exception is org.omg.CosNaming.NamingC
ontextPackage.NotFound
at org.omg.CosNaming.NamingContextPackage.NotFoundHelper.read(Unknown So
urce)
at org.omg.CosNaming.NamingContextPackage.NotFoundHelper.extract(Unknown
Source)
at org.omg.CosNaming._NamingContextStub.resolve(Unknown Source)
at com.sun.jndi.cosnaming.CNCtx.callResolve(Unknown Source)
at com.sun.jndi.cosnaming.CNCtx.lookup(Unknown Source)
at com.sun.jndi.cosnaming.CNCtx.lookup(Unknown Source)
at javax.naming.InitialContext.lookup(Unknown Source)
at Lookup.main(Lookup.java:23)
[ April 29, 2004: Message edited by: Tom Keaton ]
thanks above!
it works properly for one connection
but what about two different connections?
one is Sybase and the other maybe Oracle.
I am afraid it is hard to do.
I have two db operates to do:
insertIntoTableA();
insertIntoTableB();
I want do it at same time,two operates succeed or fail,if one of the operates fail the other operates will be cancel.Anyone can help me,
thanks in advance.

Originally posted by tvbas:
this is my code.
java.sql.SQLException


I have putted my code,please click "this",it is hyperlink of my code.

it wrong,why?
I use java to connect access db,the code appear like this:
It is no problem,but
is wrong,though the sql sentence can correctly execute by copying to access
[ March 25, 2004: Message edited by: tvbas ]
I have developed some projects use struts,I found action can not call action unless use same form ,If I use only one form in the whole project(but have many actions),action can call action,it is very useful especially they are similar.but I wonder it may cause some errors when many actions share one form.
16 years ago