MySQLTalk.org MYSQL discussions groups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  jdbcCompliantTruncation          MySQLTalk.org Forum Index -> MySQL and Java View previous topic :: View next topic   Author Message rvw Guest Posted: Wed Aug 03, 2005 1:40 pm    Post subject: jdbcCompliantTruncation It is my understanding that ther is a setting somewhere called jdbcCompliantTruncation This setting can be set to True or False. I would like to know where this setting is, so that I may change it. Back to top Ronald Boettcher Guest Posted: Wed Aug 03, 2005 3:30 pm    Post subject: Re: jdbcCompliantTruncation rvw schrieb: Quote: It is my understanding that ther is a setting somewhere called jdbcCompliantTruncation This setting can be set to True or False. I would like to know where this setting is, so that I may change it. There are at least two alternatives: 1. per URL: connectPath = "jdbc:mysql://<hostname>:3306/<dbname>?jdbcCompliantTruncation=true&<param_name>=<param_value>&..."; java.sql.Connection connection = java.sql.DriverManager.getConnection(connectPath, connectName, connectPasswd); ------- or ------ connectPath = "jdbc:mysql://<hostname>:3306/<dbname>?jdbcCompliantTruncation=true&user=<username>&password=<passowrd>&<param_name>=<param_value>&..."; java.sql.Connection connection = java.sql.DriverManager.getConnection(connectPath); 2. per Properties: java.util.Properties props = new Properties(); props.put("jdbcCompliantTruncation", "true"); props.put("user", connectName); props.put("password", connectPasswd); java.sql.Connection connection = java.sql.DriverManager.getConnection("jdbc:mysql://<hostname>:3306/<dbname>", props); Ronald Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         MySQLTalk.org Forum Index -> MySQL and Java All times are GMT Page 1 of 1   Jump to: Select a forum MySQL----------------MySQL and JavaMySQL AnnouncementsMySQL++MySQL and .NETMySQL ODBCMySQL and PerlDatabase BenchmarksMySQL BugsMySQL Cluster DiscussionMySQL CommunityMySQL DocumentationEventum DevelopmentEventum General DiscussionMySQL General DiscussionMySQL GUI ToolsMySQL InternalsMySQL CommitsMaxDBMySQL PackagersMySQL Replication DiscussionBrisbane MySQL Users GroupMySQL on Win32  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.