For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Hello Dears,
I have added a field in the NetSuite saved search,
but it couldn't appear on PBCS target application even after re-initialization.
is there a way to do such synchronization?
This fix is in 11.2.0.4
Hi,
This is what I thought originally as it was 'reported' as fixed in Oracle Support but I tested it and the problem I was facing remains. This either means the the problem I am seeing is not exactly the same (and I am happy to be corrected if this is the case) or the core problem has not been fixed. To illustrate try compiling this and testing with JDBC 11.2.0.4 against an 11.2.0.4 database (ensuring the latest ojdbc6.jar is first in your CLASSPATH and adapt for your environment)
import java.sql.*; import java.sql.SQLException; import oracle.jdbc.pool.OracleDataSource; public class OracleDriverTest { /** * @param args the command line arguments * @throws java.sql.SQLException */ public static void main(String[] args) throws SQLException { Connection connection = getConnection(); Statement stmt; stmt = connection.createStatement(); DatabaseMetaData dmd = connection.getMetaData(); ResultSet rs = dmd.getColumns("", "SCOTT", "BONUS", "%")) while (rs.next()) { System.out.println("Column: " + rs.getString("COLUMN_NAME")); System.out.println("Data type: " + rs.getInt("DATA_TYPE")); System.out.println("Size: " + rs.getInt("COLUMN_SIZE")); System.out.println("Decimal digits: " + rs.getInt("DECIMAL_DIGITS")); } } public static Connection getConnection() throws SQLException { String username = "SCOTT"; String password = "password"; String thinConn = "jdbc:oracle:thin:@//localhost/ORCL"; OracleDataSource ods; ods = new OracleDataSource(); ods.setUser(username); ods.setPassword(password); ods.setURL(thinConn); Connection conn = ods.getConnection(); DatabaseMetaData dbmd = conn.getMetaData(); System.out.println("Database : " + dbmd.getDatabaseProductVersion()); System.out.println("JDBC Driver : " +dbmd.getDriverVersion()); conn.setAutoCommit(false); return conn; } }
import java.sql.*;
import java.sql.SQLException;
import oracle.jdbc.pool.OracleDataSource;
public class OracleDriverTest {
/**
* @param args the command line arguments
* @throws java.sql.SQLException
*/
public static void main(String[] args) throws SQLException {
Connection connection = getConnection();
Statement stmt;
stmt = connection.createStatement();
DatabaseMetaData dmd = connection.getMetaData();
ResultSet rs = dmd.getColumns("", "SCOTT", "BONUS", "%"))
while (rs.next()) {
System.out.println("Column: " + rs.getString("COLUMN_NAME"));
System.out.println("Data type: " + rs.getInt("DATA_TYPE"));
System.out.println("Size: " + rs.getInt("COLUMN_SIZE"));
System.out.println("Decimal digits: " + rs.getInt("DECIMAL_DIGITS"));
}
public static Connection getConnection() throws SQLException {
String username = "SCOTT";
String password = "password";
String thinConn = "jdbc:oracle:thin:@//localhost/ORCL";
OracleDataSource ods;
ods = new OracleDataSource();
ods.setUser(username);
ods.setPassword(password);
ods.setURL(thinConn);
Connection conn = ods.getConnection();
DatabaseMetaData dbmd = conn.getMetaData();
System.out.println("Database : " + dbmd.getDatabaseProductVersion());
System.out.println("JDBC Driver : " +dbmd.getDriverVersion());
conn.setAutoCommit(false);
return conn;
When I run this against my database I see this
$ /opt/jdk1.6.0_38/bin/java OracleDriverTest
Database : Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
JDBC Driver : 11.2.0.4.0
Column: ENAME
Data type: 12
Size: 10
Decimal digits: 0
Column: JOB
Size: 9
Column: SAL
Data type: 3
Size: 0
Decimal digits: -127
Column: COMM
now compare the results when I use the oracle.jdbc.J2EE13Compliant=true argument
$ /opt/jdk1.6.0_38/bin/java -Doracle.jdbc.J2EE13Compliant=true OracleDriverTest
Size: 38
This illustrates both the problem I am facing and a potential workaround/solution. The question is - is this the same bug or something different?
Regards
Rod