How Can I Retrive A Photo In Oracle with creator 2

How Can I Retrive A Photo In Oracle with creator 2

I used the example that sun put in the site using the derby.. and now i need to make it using the oracle

but the oracle have no auto number like the example so how can i make it run ... it's hurt me for 3 weeks now can realy any one help here

[314 byte] By [MohamedEmada] at [2007-11-27 11:32:32]
# 1

helllllo can any one help me or it's hard for all

MohamedEmada at 2007-7-29 16:46:03 > top of Java-index,Development Tools,Java Tools...
# 2

See this link: http://forum.java.sun.com/thread.jspa?threadID=5099306 - I hope this helps.

thompsonwd40a at 2007-7-29 16:46:03 > top of Java-index,Development Tools,Java Tools...
# 3

well it didn't work perfectly :s

thank you so much but i need the solution urgently

MohamedEmada at 2007-7-29 16:46:03 > top of Java-index,Development Tools,Java Tools...
# 4

Are you having problems with the auto-increment feature, which does not exist in Oracle? If yes, I feel your best solution is to log on to your Oracle database and create a sequence table - do a google search on "Oracle sequences table" for examples.

Once the sequence table is built, your SQL insert code will work, with no further modifications.

thompsonwd40a at 2007-7-29 16:46:03 > top of Java-index,Development Tools,Java Tools...
# 5

in fact sir i have a problem with the sequence especially with the one that Mr. sakthi made here in his blog and it's realy urgent to solve that problem cause the system i worked in need that awfully

is there any help still

MohamedEmada at 2007-7-29 16:46:03 > top of Java-index,Development Tools,Java Tools...
# 6

I will help you the best I can -- Mr. Sakthi provided a workable example. May I ask -- Does your sequence generator work when you are in Oracle? That is, while in Oracle (for example while logged in the PL/SQL utility) can you add a row to the table, and a new sequence automatically generated?

thompsonwd40a at 2007-7-29 16:46:03 > top of Java-index,Development Tools,Java Tools...
# 7

http://forum.java.sun.com/thread.jspa?threadID=5198977&tstart=0

in the link above sir you will find another thread for me that will tell you the problem that i have with the sequence .

the sequence itself is working but the problem is in the rowset somehow..how can i make the cursor go to the next row in the other column that's all

i hope you can help me sir and thank you anyway

MohamedEmada at 2007-7-29 16:46:03 > top of Java-index,Development Tools,Java Tools...
# 8

Ok it's done

the problem with the sequence that mr Sakthi has said that i have to put the code in the prerender

while by just luck i've put it in the preprocess..that's it it worked just fine..

i hope that thread may help anyone else may Allah make it easier for all

Yours

Mohamed Emad Hegab

MohamedEmada at 2007-7-29 16:46:03 > top of Java-index,Development Tools,Java Tools...