Geek asks and answers

How to set default db schema in tomcat application context

This is my NXYTEST.xml in the local tomcat folder

<Context path="/test" reloadable="true" docBase="D:\Development\workspace\NXYTEST\WebContent" workDir="D:\Development\workspace\NXYTEST\work">
    <Resource auth="Container" driverClassName="com.ibm.db2.jcc.DB2Driver" maxActive="20" maxIdle="10" maxWait="-1" name="jdbc/ebank_ds" password="abc123" type="javax.sql.DataSource" url="jdbc:db2://172.31.17.114:60012/TESTDB" username="con2nns" />
</Context>

my project start and db connection, but an error like this:

DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: CON2NNS.PUB_APPPAR caused by: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: CON2NNS.PUB_APPPAR cause: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: CON2NNS.PUB_APPPAR

I want to set "testschema" as the default circuit, help me, thanks ...

+3
source share
1 answer

You should add url=this line to the end of your line:

:currentSchema=MySchema;

So yours will look like this:

jdbc:db2://172.31.17.114:60012/TESTDB:currentSchema=testschema;
+4
source

More articles:


All Articles