Re: Single Transaction Using Multiple Method Calls That Open New Database Connections

Thank you very much, David. I appreciate your time and consideration. I chose to use one Connection Object and pass it to all my methods so no new connections were opened. It makes my code messier, but I don't know anything about JTA. Again, thanks for the suggestion. ~Sisilla Davi

Single Transaction Using Multiple Method Calls That Open New Database Connections

ndows XP Professional. I appreciate any help. Thanks, Sisilla -- View this message in context: http://www.nabble.com/Single-Transaction-Using-Multiple-Method-Calls-That-Open-New-Database-Connections-tf3228984.html#a8971063 Sent from the Apache Derby Users mailing list archive at Nabble.com.

Date Arithmetic - Add 5-day DURATION to CURRENT_DATE

e any effort to help me. Thank you for your time and consideration. Yours, Sisilla -- View this message in context: http://www.nabble.com/Date-Arithmetic---Add-5-day-DURATION-to-CURRENT_DATE-tf3149013.html#a8729840 Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: Getting Column Names From A Table

That worked! Thank you so much. ~Sisilla Oystein Grovlen - Sun Norway wrote: > > Try using all upper case for the table name (i.e., "CLIENT"). > > -- > Øystein > > -- View this message in context: http://www.nabble.com/Getting-Column-Names-From-A-Table-tf

Getting Column Names From A Table

if (rsColumns.next()) insertString = insertString + ", "; } I am using Derby 10.2.1.6 and JDK 1.6.0 on Windows XP Professional. What am I overlooking here? I appreciate any help. Thanks, Sisilla -- View this mes

Re: java method called from a JSP cannot load ClientDriver

Thank you, Knut, for your reply and your efforts to help me. It turns out that the fields I thought contained null values actually contained empty strings, so the NOT NULL constraints are working fine. ~Sisilla Knut Anders Hatlen wrote: > > Sisilla <[EMAIL PROTECTED]> writes: >

Re: java method called from a JSP cannot load ClientDriver

Hello Again, It seems that my java program ignores the NOT NULL column constraints that I have declared on my derby database table. What am I missing here? I appreciate any help. Thanks, Sisilla Sisilla wrote: > > Thank you, Lance, for your help. I installed the driver in common/li

Re: java method called from a JSP cannot load ClientDriver

Thank you, Lance, for your help. I installed the driver in common/lib, and the JSP is working now. I greatly appreciate this. ~Sisilla Lance J. Andersen wrote: > > Where is the driver installed in tomcat and how are you accessing it? > Normally the drivers would go in common/lib and

java method called from a JSP cannot load ClientDriver

5.5.9 on Windows XP Pro. I am also using Netbeans IDE 5.0. I greatly appreciate any help. Thanks, Sisilla package Sales; import java.sql.*; public class NewClient { public NewClient() { } public boolean addNewClient(String company, String industry, String

Does Derby support ASSERTION?

ror message: An error has occurred during execution: Syntax error: Encountered "ASSERTION" at line 1, column 8 I am using Derby 10.2.1.6 on Windows XP Professional. I appreciate any help. Thanks, Sisilla

comparisons are not supported for long varchar datatype

,     NationalID VARCHAR(55) NOT NULL,     FirstName VARCHAR(55) NOT NULL,     Surname VARCHAR(55) NOT NULL,     PRIMARY KEY (PTTEmployeeID),     UNIQUE (NationalID) )   I appreciate any help.   Thanks, Sisilla