The error I got was "Table already exists: JCS_STORE_SHRINK in statement
[CREATE CACHED TABLE JCS_STORE_SHRINK]"
How about the attached patch instead?
Looks like my commit made no difference to the continuum problem :-(
On Sat, 6 Feb 2016 at 17:42 Thomas Vandahl <[email protected]> wrote:
> Hi Mat,
>
> On 03.02.16 17:44, Mat Jaggard wrote:
> > I have three patches that might be helpful...
> >
> > 1. Javadoc changes to make it compile on my machine
> > 2. Server port changes which may (or may not) fix the continuum unit
> > test issue
> > 3. Change to the way existing tables are detected (I think I got a
> > different SQL error code)
>
> Thanks again for contributing. I applied patches 1 and 2. I'm not so
> sure about 3.
> The check for SQL state 23000 is quite common. We use the same check in
> DB Torque for several different database systems with good success.
> What error message did you get?
>
> Bye, Thomas.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
Index: HsqlSetupTableUtil.java
===================================================================
--- HsqlSetupTableUtil.java (revision 1726611)
+++ HsqlSetupTableUtil.java (working copy)
@@ -60,7 +60,7 @@
}
catch ( SQLException e )
{
- if ("23000".equals(e.getSQLState()))
+ if ("23000".equals(e.getSQLState()) || ("S0001".equals(e.getSQLState()) && e.getErrorCode() == -21))
{
newT = false;
}
Index: JDBCDiskCacheShrinkUnitTest.java
===================================================================
--- JDBCDiskCacheShrinkUnitTest.java (revision 1726611)
+++ JDBCDiskCacheShrinkUnitTest.java (working copy)
@@ -254,7 +254,7 @@
}
catch ( SQLException e )
{
- if ("23000".equals(e.getSQLState()))
+ if ("23000".equals(e.getSQLState()) || ("S0001".equals(e.getSQLState()) && e.getErrorCode() == -21))
{
newT = false;
}
Index: mysql/MySQLDiskCacheHsqlBackedUnitTest.java
===================================================================
--- mysql/MySQLDiskCacheHsqlBackedUnitTest.java (revision 1726611)
+++ mysql/MySQLDiskCacheHsqlBackedUnitTest.java (working copy)
@@ -207,7 +207,7 @@
}
catch ( SQLException e )
{
- if ("23000".equals(e.getSQLState()))
+ if ("23000".equals(e.getSQLState()) || ("S0001".equals(e.getSQLState()) && e.getErrorCode() == -21))
{
newT = false;
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
