Phoenix Online Data Mining Utility

Here it is at http://69.197.142.200:8080/Phoenix/ , our group project for cs9323 course. this web app basically does some data mining tasks online. Not really a brilliant idea to do data mining online but that was what we were given.

Moving database file and renaming database file

exec sp_helpdb DatabaseName

datach:

exec sp_detach_db 'MyDatabase', 'true'

attach:

exec sp_attach_db 'MyDatabase',
'C:\Program Files\Microsoft SQL Server\MSSQL\data\MyDatabase_Data.MDF',
'C:\Program Files\Microsoft SQL Server\MSSQL\data_log\MyDatabase_Log.LDF'

Change logical file name:

alter database MyDatabase modify file (name='test', newname='MyDatabase')
alter database MyDatabase modify file (name='test_log', newname='MyDatabase_log')

source: Timothy Chen Allen

A quick tutorial on using hibernate for webapp

Directly from Netbeans KB:
http://www.netbeans.org/kb/docs/web/hibernate-webapp.html
However, don't expect to learn much from this over simplified tutorial.

Using Netbeans and Eclipse side by side with SVN

while I was doing the group assignment for comp9323, I thought about using netbeans and eclipse side by side. Initially I preferred Netbeans but after all I was using Eclipse for the project.
After playing around Subversion and Netbeans/Eclipse for a while, I actually realize that this can be setup in a way that netbeans and eclipse can be used side by side in same project. In my case, I created the source repository in SVN then synchronize it with Eclipse, later I use Netbeans to check out a copy then follow the instructions to create netbeans project, when it complaints about existing build folder, just remove the build folder then you can proceed.

"Media is Write Protected" in windows server 2008 shared drive

Just solved an issue with users at Melbourne office, apparantly something got changed to their mapped network drive and they can't write to the shared drive.

Agains, a technet article explained this and the solution:

You may see "Media is Write Protected" Error or VDS error 80070013 after bringing SAN disk online via Diskpart in Windows Server 2008
http://support.microsoft.com/kb/971436

Epicor E4SE and eBackoffice Go Live

Finally, it is time.
E4SE 811 and eBackoffice 736 will replace our current 810b/735a environment after staying so many years.
Just got the new test environment up together with the training environment.
time to go sleep now.

setting up datasource in tomcat & glassfish appserv

Notes to setup mysql datasource in tomcat/sunappserv (for my cs9323 assignment):

1. copy mysql-connector-java-5.1.8-bin.jar to c:\\tomcat6\lib or c:\\sun\appserv\lib

2. Add the following section to c:\\tomcat6\conf\context.xml
<br /><Resource name="jdbc/mydb" auth="Container" type="javax.sql.DataSource" <br /> maxActive="100" maxIdle="30" maxWait="10000" <br /> username="root" password="pass" driverClassName="com.mysql.jdbc.Driver" <br /> url="jdbc:mysql://localhost:3306/mydb"/><br />
For glassfish, go to http://localhost:4848 and create a pool under 'Resource/Connection Pools' then create a jdbc resource called 'jdbc/mydb' in 'Resources/JDBC Resouces'. (you need to specific host,port, user, pass,db in the pool settings)

3. Under webcontent\META-INF, edit context.xml to include the following section:

<br /><Context><br /><Resource name="jdbc/mydb" auth="Container"<br />type="javax.sql.DataSource"<br />username="root" password="pass"<br />driverClassName="com.mysql.jdbc.Driver"<br />url="jdbc:mysql://localhost:3306/mydb"<br />maxActive="8" /><br /></Context><br />

Alternatively, this can be done via adding the following section into WEB-INF/web.xml:

<br /> <resource-ref><br /> <description>DB Connection</description><br /> <res-ref-name>jdbc/mydb</res-ref-name><br /> <res-type>javax.sql.DataSource</res-type><br /> <res-auth>Container</res-auth><br /> </resource-ref> <br />

4. for tomcat, use the following code to do the lookup:
<br /> Context initContext = new InitialContext();<br /> Context envContext = (Context)initContext.lookup("java:/comp/env");<br /> DataSource ds = (DataSource)envContext.lookup("jdbc/mydb");<br /> Connection conn = ds.getConnection();<br />

For glassfish:
<br /> InitialContext context = new InitialContext();<br /> DataSource ds= (DataSource) context.lookup("jdbc/mydb");<br /> Connection conn = ds.getConnection();<br />