Re: java method called from a JSP cannot load ClientDriver

2006-12-07 Thread Sisilla
you could post the statements you used > for creating the table and the constraints, as well as an example of a > statement that violates the constraints. > > -- > Knut Anders > > -- View this message in context: http://www.nabble.com/java-method-called-from-a-JSP-canno

Re: java method called from a JSP cannot load ClientDriver

2006-12-06 Thread Knut Anders Hatlen
Sisilla <[EMAIL PROTECTED]> writes: > 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. Hi Sisilla, It would be easier to help if you could post the statements

Re: java method called from a JSP cannot load ClientDriver

2006-12-06 Thread Sisilla
>>> System.out.println(" . . . exception >>> thrown:"); >>> errorPrint(e); >>> return false; //INSERT unsuccessful >>> } >>> } >>> >>> // ## DERBY EXCEPTION REPORTING CLASSES ## >>> /*** Exception reporting methods >>> ** with special handling of SQLExceptions >>> ***/ >>> static void errorPrint(Throwable e) >>> { >>> if (e instanceof SQLException) >>> SQLExceptionPrint((SQLException)e); >>> else >>> { >>> System.out.println("A non SQL error occured."); >>> e.printStackTrace(); >>> } >>> }// END errorPrint >>> >>> // Iterates through a stack of SQLExceptions >>> static void SQLExceptionPrint(SQLException sqle) >>> { >>> while (sqle != null) >>> { >>> System.out.println("\n---SQLException Caught---\n"); >>> System.out.println("SQLState: " + >>> (sqle).getSQLState()); >>> System.out.println("Severity: " + >>> (sqle).getErrorCode()); >>> System.out.println("Message: " + (sqle).getMessage()); >>> sqle.printStackTrace(); >>> sqle = sqle.getNextException(); >>> } >>> }// END SQLExceptionPrint >>> >>> } >>> >> >> > > -- View this message in context: http://www.nabble.com/java-method-called-from-a-JSP-cannot-load-ClientDriver-tf2768547.html#a7725706 Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: java method called from a JSP cannot load ClientDriver

2006-12-06 Thread Sisilla
ceptions >> ***/ >> static void errorPrint(Throwable e) >> { >> if (e instanceof SQLException) >> SQLExceptionPrint((SQLException)e); >> else >> { >> System.out.println("A non SQL error occured."); >> e.printStackTrace(); >> } >> }// END errorPrint >> >> // Iterates through a stack of SQLExceptions >> static void SQLExceptionPrint(SQLException sqle) >> { >> while (sqle != null) >> { >> System.out.println("\n---SQLException Caught---\n"); >> System.out.println("SQLState: " + >> (sqle).getSQLState()); >> System.out.println("Severity: " + >> (sqle).getErrorCode()); >> System.out.println("Message: " + (sqle).getMessage()); >> sqle.printStackTrace(); >> sqle = sqle.getNextException(); >> } >> }// END SQLExceptionPrint >> >> } >> > > -- View this message in context: http://www.nabble.com/java-method-called-from-a-JSP-cannot-load-ClientDriver-tf2768547.html#a7725085 Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: java method called from a JSP cannot load ClientDriver

2006-12-06 Thread Lance J. Andersen
Where is the driver installed in tomcat and how are you accessing it? Normally the drivers would go in common/lib and you would create an entry in the server.xml to access the DataSource Sisilla wrote: Hello All, I am using a java program (code shown below) to insert some records into a derb

java method called from a JSP cannot load ClientDriver

2006-12-06 Thread Sisilla
System.out.println("SQLState: " + (sqle).getSQLState()); System.out.println("Severity: " + (sqle).getErrorCode()); System.out.println("Message: " + (sqle).getMessage()); sqle.printStackTrace(); sqle = sqle.getNextException(); } }// END SQLExceptionPrint } -- View this message in context: http://www.nabble.com/java-method-called-from-a-JSP-cannot-load-ClientDriver-tf2768547.html#a7720814 Sent from the Apache Derby Users mailing list archive at Nabble.com.