A weird issue

[Cui Xiaojing-a13339]

Hello All,

Now my software platform as below:

Windows 2000
JDK1.4.1_02
Tomcat 4.1.24
Sql Server 2000

I have a piece of code as below:

        private String jdbcDriverClass="sun.jdbc.odbc.JdbcOdbcDriver";
        private String jdbcURL="jdbc:odbc:cfdata";
        private String jdbcUserName="sss";
        private String jdbcPassword="sss";
        try {
                Class.forName(jdbcDriverClass);
                con=DriverManager.getConnection(jdbcURL, jdbcUserName, jdbcPassword);
                stmt=con.createStatement();
        } catch (SQLException se) {
                throw new RuntimeException("A database error occured. " + 
se.getMessage());
        
        try{
                String sqls="select CID from CF_GDW_Load";
                rs=stmt.executeQuery(sqls);
        }

This piece of code is run in tomcat. It will extract data from table in Sql Server 
2000. In Sql Server 2000, the table is named as CF_GDW_LOAD, but in the code I write 
it as CF_GDW_Load. I know that itis not case sensitive in Sql Server, but when I run 
this piece code in Tomcat, an exception occurs. it says that [Microsoft][ODBC SQL 
Server Driver][SQL Server]Invalid object name 'CF_GDW_Load'. If I change CF_GDW_Load 
to CF_GDW_LOAD in the code, no exception occurs. So in here it is case sensitive. But 
making me surprised is that on the same software platform, I run another piece of code 
in Tomcat, it extract data from a table in another database in Sql Server 2000, it is 
not case sensitive. Do you have any idea about the weird issue? Thanks.

Regards,
Xiaojing


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]